Skip site navigation (1) Skip section navigation (2)

Re: Periodically slow inserts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gael Le Mignot <gael(at)pilotsystems(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Periodically slow inserts
Date: 2010-10-21 16:50:00
Message-ID: 25979.1287679800@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Bruce MomjianDate: 2010-10-21 16:51:09
Subject: Re: BBU Cache vs. spindles
Previous:From: Steve CrawfordDate: 2010-10-21 16:42:52
Subject: Re: BBU Cache vs. spindles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group