Gael Le Mignot <gael@xxxxxxxxxxxxxxxx> writes: > Thu, 21 Oct 2010 10:55:48 -0400, you wrote: >>> I think this may be caused by GIN's habit of queuing index insertions >>> until it's accumulated a reasonable-size batch: >>> http://www.postgresql.org/docs/9.0/static/gin-implementation.html#GIN-FAST-UPDATE > So a big work_mem and a regular vacuum would do the tick, I think. Does > auto_vacuum triggers the gin index vacuuming too, or does it require a > manual vacuum ? Autovacuum will handle it too. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
