On Jan 18, 2011, at 1:58 PM, Tom Lane wrote: > I'm noticing also that I get different rowcounts than you do, although > possibly that has something to do with the partial-index conditions, > which I'm not trying to duplicate here (all rows in my table pass those > two tests).
Shall I send you data with the other two columns?: >> * Why does it take 3-4x longer to create the GIN than the GiST index >> on tsvector? > > Perhaps more maintenance_work_mem would help with that; although the > fine manual says specifically that GIN text search indexes take about > three times longer to build than equivalent GiST indexes, so maybe that > behavior is as designed. Okay then, thanks. David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
