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.
