I am trying to use a full text index, but it seems to be reindexing on
every query.
The query plan looks fine, but the queries take extremely long (hours
even). I think it is reindexing because it is notifying me that
certain long "words" won't be indexed as you can see below, which is
w
Based on suggestions from this list, I am trying to create a tsvector
column and index that, since it is perhaps the recheck and rebuilding
of all the vectors that is slowing things down. I don't understand
why a recheck is necessary on a gin index.
My update statement has been running
rs = 24MB # min 128kB or max_connections*16kB
work_mem = 10MB # min 64kB
max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
Oleg
On Tue, 3 Feb 2009, Alex Neth wrote:
Based on suggestions from this list, I am trying to create a
tsvec
