On Mon, 2011-12-19 at 19:08 +0200, Marti Raudsepp wrote: > Another thought -- have you read about the GIN "fast updates" feature? > This existed in 9.0 too. Instead of updating the index directly, GIN > appends all changes to a sequential list, which needs to be scanned in > whole for read queries. The periodic autovacuum process has to merge > these values back into the index. > > Maybe the solution is to tune autovacuum to run more often on the > table. > > http://www.postgresql.org/docs/9.1/static/gin-implementation.html > > Regards, > Marti
Probably this is the problem. Is running "vacuum analyze" under psql is the same as "autovacuum"? -Sushant. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers