Alexander
Alexander
Yes, i got HUGE strings in this table, not the only one, a column with ts_vector of it and a gin index on it.
Glad to hear that you are working on this issue. We are not using these urls at the moment, but they can be used in the near future. So, it...
Can you trim the url and raise some notice like: > NOTICE: Index key can't have size more than 1336 bytes. > HINT: key has been trimmed.
> I think we can trim the url also. We will fix limits for posting trees, and they will become as in GIN. Sounds great, thank you.
@select-artur, still having the same problem: `ERROR: index row size 1544 exceeds maximum 1352 for index "some_index"`
> Please, try commit 58fee28. Well, installed it, tests are ok, rebuilded the extension, started the creation of the index, and ... about 3 hours of total suffering of the...
Here you are: ``` Table size: 20 GB + 51 GB toast, Rows count: 19890432, Index on search_vector: 6137 MB, RAM: 25.36 GB, Number of processors: 8, Disk type: ssd,...
Sorry, but no, and no. This information is some kind confidential.
Not a good variant too, because the random data will give different size of the vector, tockens and so on.