PG vector similarity search failing

[GautamR-Samagra]

Similarity search returns no results (returns empty string) on queries randomly (happens rarely). Usually seen on repeating a message multiple times.

Run below query multiple times (It gives zero result at random)

SELECT * FROM match_documents(
    query_embedding := '[-0.02666974999010563,0.00577892130240798,0.003843582235276699,-0.023892108350992203,0.019308701157569885,0.02682262659072876,0.0034888924565166235,0.0107962591573596,-0.017848681658506393,0.03433484211564064,0.005119918379932642,-0.018802983686327934,0.036345336586236954,0.038567714393138885,-0.052534069865942,0.0185250174254179,-0.024546487256884575,0.0006230336730368435,-0.07606494426727295,0.006566066760569811,0.02765425108373165,-0.0012760946992784739,0.013011148199439049,0.04887739196419716,-0.009048341773450375,0.03277412801980972,-0.0037475924473255873,0.003633099840953946,0.05767464265227318,-0.01864638179540634,0.024835627526044846,-0.06208881735801697,-0.044366057962179184,-0.023829858750104904,-0.04466863349080086,-0.0013776140986010432,0.015400514006614685,0.0014044862473383546,0.04577701538801193,0.044750016182661057,-0.016420841217041016,0.006801469251513481,-0.012176389805972576,-0.022026868537068367,0.00947519764304161,0.024266377091407776,-0.042482130229473114,-0.030538957566022873,0.004020099062472582,-0.03515394777059555,-0.07407668232917786,-0.02796771749854088,-0.031583886593580246,0.01897875964641571,-0.019067728891968727,-0.05087854340672493,-0.055498071014881134,0.0139984842389822,0.08235643804073334,-0.04185130074620247,-0.01161505188792944,0.005609177518635988,-0.115245021879673,-0.006262785755097866,0.03362131863832474,-0.04472217336297035,0.022047096863389015,-0.04401540011167526,0.0002140862197848037,-0.020000873133540154,-0.014451383613049984,-0.05745100975036621,0.03401241824030876,-0.07163851708173752,-0.03878151625394821,-0.0070478711277246475,0.0511443056166172,0.02013261802494526,-0.043151065707206726,0.021540647372603416,-0.017383061349391937,0.01688663475215435,0.05274980515241623,-0.03605915978550911,-0.00019395872368477285,-0.004838051740080118,-0.017554249614477158,0.03445468097925186,0.015626179054379463,0.03886234015226364,-0.05436807498335838,-0.03912680223584175,-0.0033813007175922394,-0.03544260188937187,-0.021311994642019272,0.04094967618584633,0.05159042403101921,0.015616514720022678,0.02992214821279049,0.06140259653329849,0.05120757222175598,0.024009156972169876,-0.034248530864715576,0.046305857598781586,-0.001185997505672276,0.016699666157364845,-0.004886229522526264,-0.03605341911315918,-0.053550224751234055,0.019279368221759796,-0.03733021765947342,-0.047865405678749084,-0.0338231660425663,0.030005404725670815,0.011574607342481613,-0.017303716391324997,0.0492897555232048,-0.025467390194535255,-0.05260048434138298,-0.03952464833855629,0.037224601954221725,0.01250084675848484,0.007494933903217316,-0.006638180464506149,-0.04224430397152901,0.000026995387088391,-0.04610113799571991,-0.017596513032913208,-0.04405941814184189,-0.004446377512067556,-0.010719412006437778,0.014070268720388412,0.009641220793128014,-0.04528145492076874,0.018503781408071518,0.03695113584399223,-0.042458657175302505,0.04105440154671669,0.0018164237262681127,0.10831958055496216,-0.06649955362081528,-0.02700948528945446,-0.024136390537023544,0.018471185117959976,-0.04306008666753769,0.006042856723070145,-0.0056631481274962425,-0.04325287044048309,-0.029423199594020844,-0.030205728486180305,0.04463646933436394,-0.036404721438884735,0.010709639638662338,0.055159665644168854,0.0033198148012161255,0.04232793301343918,-0.049473147839307785,-0.006205232813954353,-0.0223326925188303,0.021212371066212654,-0.029080022126436234,0.0674843043088913,-0.046843234449625015,-0.00862036645412445,-0.063759446144104,-0.025650128722190857,-0.0082106813788414,0.051935020834207535,-0.005822575185447931,-0.03154236450791359,-0.07796014845371246,0.016092929989099503,0.03564320132136345,0.04255247488617897,-0.038522254675626755,0.0350315235555172,0.05282052233815193,0.030510341748595238,-0.011322781443595886,0.03308972343802452,0.006129872985184193,-0.024835973978042603,-0.04689161852002144,0.02225712314248085,0.04666591063141823,-0.002496859524399042,-0.021995753049850464,0.02955278940498829,0.02638271078467369,-0.05352780595421791,-0.02304111421108246,0.034159690141677856,-0.011171492747962475,-0.025562187656760216,0.032836172729730606,-0.020339297130703926,-0.029315702617168427,0.031010650098323822,-0.0032464913092553616,0.0036005843430757523,-0.035398975014686584,-0.0035850517451763153,0.043496038764715195,0.0014337025349959731,0.04220272973179817,0.06980255991220474,-0.0007818281883373857,0.09032455086708069,-0.03987031430006027,0.008760441094636917,-0.03571787849068642,-0.040978945791721344,0.0010000676847994328,0.05160052329301834,0.0800166130065918,0.03148187696933746,-0.048907067626714706,-0.09438000619411469,0.05106223747134209,0.024854714050889015,0.027048034593462944,0.015463307499885559,-0.03224167972803116,0.020798996090888977,0.02114591747522354,0.024191321805119514,-0.04253849759697914,-0.05981249734759331,0.0292630884796381,0.04648570343852043,0.0067282975651323795,-0.0024982013273984194,-0.021246440708637238,0.0029553750064224005,-0.030110366642475128,-0.07453019171953201,0.030974099412560463,0.021769268438220024,0.012330767698585987,0.0013050599955022335,-0.06423579901456833,0.023433290421962738,0.05427345260977745,0.032079532742500305,0.0015656484756618738,-0.037206027656793594,0.008724345825612545,-0.02065148577094078,0.055724043399095535,-0.01617560163140297,0.06470120698213577,0.005342558026313782,0.027843263000249863,0.012098155915737152,-0.022344542667269707,0.045177798718214035,0.03453744575381279,0.008991283364593983,-0.024725858122110367,0.05334258824586868,0.00554764224216342,0.034018903970718384,0.09425245225429535,-0.006165148224681616,0.08635660260915756,-0.02256513573229313,0.04054076969623566,0.022426795214414597,0.01867864280939102,0.007631221786141396,0.07131728529930115,0.058325428515672684,-0.032491285353899,0.007226087152957916,0.025409407913684845,-0.06119963154196739,0.0090315081179142,-0.028734227642416954,0.006088847294449806,-0.023229746147990227,-0.011473288759589195,0.0743330791592598,-0.005669994279742241,0.005206156987696886,-0.01302817277610302,0.0006621365901082754,-0.010475050657987595,0.027522431686520576,-0.005901339463889599,0.02217947505414486,-0.0032687780912965536,-0.04284229874610901,0.03706442937254906,-0.0742727518081665,-0.02459779568016529,-0.000018627901226864196,-0.042893923819065094,-0.017148401588201523,-0.08041208237409592,-0.005946575663983822,-0.03336773440241814,-0.0023651837836951017,0.05071999877691269,0.02185552753508091,0.030000682920217514,-0.0109573844820261,0.02551935613155365,-0.02146657183766365,-0.05721880495548248,-0.07746168226003647,-0.05157226696610451,-0.030466672033071518,-0.0649183914065361,0.04332449659705162,0.05593203753232956,-0.005228011403232813,0.031720831990242004,0.009227373637259007,-0.03837038576602936,-0.023338202387094498,0.04752907529473305,0.03925953805446625,-0.01314827986061573,-0.02360496111214161,0.01721022091805935,0.036150116473436356,-0.00912407785654068,-0.017969081178307533,-0.034684184938669205,0.05533810704946518,0.06772594153881073,0.02540169097483158,-0.013286394998431206,-0.00010186310100834817,-0.021301614120602608,-0.024964287877082825,-0.04995338246226311,-0.03043903037905693,-0.010502235032618046,-0.03995973616838455,-0.03166092559695244,0.00903022289276123,-0.055382076650857925,-0.035668402910232544,-0.025770917534828186,-0.02543262206017971,0.018201885744929314,0.04199426993727684,0.009891744703054428,0.020499682053923607,-0.030294565483927727,-0.03076997585594654,0.04243328422307968,-0.024955499917268753,-0.01786765642464161,-0.07453992962837219,-0.01167883351445198,0.030572941526770592,0.006422725971788168,0.03337276726961136,-0.05522807314991951,0.05065031722187996,0.0667119175195694,-0.01349522266536951,0.02062232792377472,-0.02656480111181736,-0.03787991777062416,-0.014544909819960594,-0.009222356602549553,-0.016800250858068466,-0.03533922880887985,-0.009897577576339245,-0.014317808672785759,0.03629039600491524,-0.02779870107769966,-0.04907291382551193,-0.03591933101415634,0.02769276313483715,0.015599120408296585,0.03227198123931885,-0.03227386623620987,0.005853458307683468,-0.05271177738904953,0.02798323892056942,-0.00030754535691812634,-0.0007245455635711551,0.026150574907660484,0.059340424835681915,0.02426406554877758,0.013125854544341564,0.0545000322163105,0.025119559839367867,0.07510706037282944,0.04102262482047081,-0.030549263581633568,0.03082423284649849,-0.01920980215072632,0.04059164971113205,0.004970104433596134,-0.008259978145360947,-0.0891309306025505,-0.05720478296279907,-0.007947073318064213,0.014160101301968098,-0.028625059872865677,0.0008156928815878928,0.04087978973984718,-0.014313112944364548,-0.007593104150146246,-0.006102901417762041,-0.0071862670592963696,0.01954011246562004,-0.025376182049512863,0.06047595292329788,-0.02688230387866497,0.018769731745123863,-0.023200087249279022,0.0060997228138148785,-0.0514904223382473,-0.05069718509912491,0.008228865452110767,0.07145531475543976,0.06947583705186844,0.062181420624256134,0.04894142970442772,-0.03881412744522095,-0.026904065161943436,0.03562392294406891,0.03919217735528946,-0.010791487991809845,-0.034238193184137344,0.018343310803174973,0.004814102314412594,0.006782802753150463,0.02364393137395382,-0.01705240271985531,0.009082392789423466,0.060686927288770676,-0.011815227568149567,-0.012245707213878632,0.00325748766772449,0.004290394484996796,-0.04813285544514656,-0.04405102878808975,0.04689366742968559,-0.01711946725845337,-0.006374644581228495,0.04526219889521599,0.021250763908028603,-0.03261171281337738,0.0599210299551487,0.031693633645772934,-0.022186579182744026,-0.042787931859493256,0.04392799735069275,0.02612147480249405,-0.02952120639383793,-0.0740879699587822,-0.033771321177482605,0.02288658916950226,0.056143052875995636,-0.017682397738099098,-0.05609830096364021,0.013161290436983109,0.040953148156404495,-0.05938173830509186,0.058322809636592865,0.02197430282831192,0.010459024459123611,0.05903360992670059,-0.0094155790284276,0.003207427216693759,-0.03474270924925804,0.014301065355539322,-0.014537772163748741,0.03266460821032524,-0.008359073661267757,-0.0376809686422348,-0.016210537403821945,0.01480873767286539,0.03164554014801979,0.0434514619410038,0.026221148669719696,-0.01768876239657402,-0.02498098649084568,-0.04195103049278259,0.08178403228521347,-0.031444016844034195,0.05266392603516579,0.04403749108314514,0.0683789849281311,-0.030916672199964523,-0.052156805992126465,0.023211725056171417,0.0033195388969033957,0.04327451437711716,-0.013069512322545052,-0.04064592719078064,-0.04399161785840988,-0.0004852251731790602,0.010547026060521603,-0.003405950265005231,-0.10871436446905136,0.010871486738324165,-0.03365596383810043,-0.030022170394659042,0.02463158592581749,0.06696128845214844,0.040494270622730255,0.045216649770736694,-0.03676224499940872,0.0033375422935932875,-0.020455893129110336,0.06306765973567963,-0.026366032660007477,-0.04370909929275513,0.011233661323785782,-0.0385601744055748,0.0014019467635080218,-0.03733084350824356,-0.019110573455691338,-0.054611459374427795,-0.016278302296996117,0.010794907808303833,-0.036005984991788864,-0.013572169467806816,-0.009185169823467731,0.024879215285182,-0.02798767201602459,-0.018939483910799026,-0.014103218913078308,-0.06481959670782089,-0.026290835812687874,-0.04281504824757576,0.03448498621582985,0.00042763061355799437,0.00158646609634161,-0.003903864184394479,0.03657003119587898,-0.022664235904812813,0.038547031581401825,-0.04302401468157768,0.014921722933650017,0.022169919684529305,-0.017957448959350586,-0.00540980976074934,-0.01829596422612667,0.02515305019915104,0.03631950169801712,-0.04254978895187378,0.0431869737803936,0.010070554912090302,-0.007840532809495926,-0.027000317350029945,0.02271410822868347,0.012275854125618935,-0.031483665108680725,-0.004231332801282406,-0.027050884440541267,-0.02481745183467865,0.04227223992347717,-0.04144970700144768,-0.02528279647231102,-0.016541657969355583,0.023844121024012566,0.04600432887673378,-0.011888335458934307,-0.04397263377904892,0.053348641842603683,-0.02008148469030857,0.026186833158135414,-0.042690031230449677,0.011186693795025349,-0.025650514289736748,0.038829412311315536,-0.003856573486700654,0.0013770603109151125,-0.07254643738269806,0.03163700923323631,-0.03924386948347092,-0.029146287590265274,-0.03438445180654526,0.014488961547613144,-0.045474957674741745,0.05367550998926163,-0.007971667684614658,-0.005665197037160397,-0.03328872099518776,0.06162639334797859,-0.04623845964670181,-0.00685360562056303,0.016237810254096985,-0.0027135706041008234,-0.058335043489933014,-0.018780667334794998,-0.01552575919777155,-0.0488908588886261,-0.007013101130723953,0.05260781943798065,0.022890446707606316,0.0026589096523821354,-0.020037181675434113,-0.02875681407749653,0.017692606896162033,-0.0210877712816,-0.011091195046901703,-0.009314815513789654,-0.019212914630770683,-0.01836266741156578,0.0476885586977005,0.04920632019639015,-0.05116114765405655,-0.028145460411906242,0.05372927337884903,0.03403801470994949,0.02557877078652382,-0.029930924996733665,-0.006434891372919083,0.007355567999184132,0.02508942037820816,-0.01809328980743885,-0.015711840242147446,-0.025871263816952705,-0.03583068028092384,-0.029313944280147552,-0.005155677907168865,0.03019184246659279,-0.0005891348118893802,-0.005640124902129173,-0.024803951382637024,0.09889279305934906,0.05912785604596138,0.010300246998667717,-0.005679786205291748,-0.06568966060876846,0.024689683690667152,0.019045963883399963,-0.02878984995186329,-0.0014367072144523263,0.005222817417234182,-0.04582449793815613,0.07020650058984756,-0.010764466598629951,0.030410341918468475,0.0351305827498436,0.017981966957449913,-0.013240525498986244,0.05847463384270668,-0.04580438882112503,-0.007191360462456942,0.037428054958581924,-0.04596356675028801,-0.034057147800922394,0.018276212736964226,0.03727557510137558,-0.050810087472200394,0.06896122545003891,0.016380492597818375,-0.011468582786619663,0.01497106533497572,-0.06634347885847092,0.012227286584675312,0.022364141419529915,-0.025077393278479576,0.0490088127553463,0.0012615978484973311,-0.04349173977971077,0.017014378681778908,0.018478406593203545,-0.08771432936191559,-0.0014370206044986844,0.000502937997225672,0.00880118552595377,0.036543507128953934,0.04061908274888992,-0.07281512022018433,-0.028563043102622032,-0.017530104145407677,0.06306526064872742,-0.03024415858089924,-0.01775754988193512,-0.0020990711636841297,-0.0240780059248209,-0.012099485844373703,0.05739213153719902,-0.032963354140520096,0.038851719349622726,0.06186365336179733,-0.058271754533052444,-0.09089019149541855,0.023216640576720238,0.0576789453625679,0.013456584885716438,-0.020662963390350342,-0.004935001488775015,-0.010355970822274685,-0.000018394386643194593,0.012283634394407272,-0.034155309200286865,0.019640296697616577,0.02917262725532055,-0.05764808505773544,0.00729270139709115,0.03371286392211914,0.033105555921792984,-0.01938166469335556,0.02863416075706482,-0.014809251762926579,0.03745337948203087,0.04413875937461853,-0.0030362566467374563,0.013602855615317822,-0.03564872220158577,-0.0038946629501879215,0.027015643194317818,0.008381780236959457,0.0624062605202198,-0.037455905228853226,0.0059593147598207,0.04112686216831207,0.04317816346883774,0.015218427404761314,-0.0346076525747776,-0.0492691770195961,0.00586936017498374,-0.04564802348613739,-0.007961690425872803,-0.007521449588239193,-0.03526211529970169,-0.054142728447914124,-0.011499804444611073,-0.01933193765580654,0.03159450739622116,-0.02119717188179493,0.03538276255130768,0.015047552064061165,0.04089788347482681,-0.03692246600985527,-0.07277503609657288,-0.03550920635461807,-0.04499271139502525,0.04043974354863167,0.019383350387215614,0.0031637633219361305,0.007674194406718016,-0.019520791247487068,-0.025363432243466377,0.04237518832087517,0.0026558104436844587,-0.034245312213897705,0.04007403925061226,0.04675251618027687,-0.03358990326523781,0.01223190501332283,0.05033339187502861,-0.06423542648553848,0.05592014640569687,0.016361238434910774,-0.006612358149141073,0.0265838410705328,0.028124326840043068,-0.021893493831157684,-0.04000907391309738,-0.059645410627126694,-0.0399915911257267,-0.03253845497965813,0.00798136368393898,0.07015029340982437]',
    pdfIds := ARRAY['dc5e84a1-b9d6-4847-b779-eb791fbec4c7'],
    similarity_threshold := 0,
    match_count := 10
);