Re: Periodically slow inserts - Mailing list pgsql-performance

From Tom Lane
Subject Re: Periodically slow inserts
Date
Msg-id 25979.1287679800@sss.pgh.pa.us
Whole thread Raw
In response to Re: Periodically slow inserts  (Gael Le Mignot <gael@pilotsystems.net>)
Responses Re: Periodically slow inserts  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-performance
Gael Le Mignot <gael@pilotsystems.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

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: BBU Cache vs. spindles
Next
From: Bruce Momjian
Date:
Subject: Re: BBU Cache vs. spindles