Gael Le Mignot <gael(at)pilotsystems(dot)net> 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