3 ms·
> usually big enough to be stored in a TOAST table Ah, luckily, in my case, that can’t happen – each row’s message contains one IRC message, so at most 512 byt
by kuschku 10y ago
> usually big enough to be stored in a TOAST table
Ah, luckily, in my case, that can’t happen – each row’s message contains one IRC message, so at most 512 bytes. That also automatically ensures we’ll never run into TOAST issues.
- ngrilly 10y agoNow I understand why you didn't suffer from the slow ranking issue. In my test case, text is longer and triggers the TOAST management code.
- kuschku 10y agoYeah, if your vectors are in TOAST, you really have a huge issue with ranking. There’s no simple way to get around that, except with customized solutions like Lucene/Solr/ES