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

Re: Periodically slow inserts

From: Leonardo Francalanci <m_lists(at)yahoo(dot)it>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gael Le Mignot <gael(at)pilotsystems(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Periodically slow inserts
Date: 2010-10-22 07:45:02
Message-ID: 191365.6037.qm@web29002.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
>>> I  think this may be caused by GIN's habit of queuing index  insertions
>>> until it's accumulated a reasonable-size  batch:

So the fact that it takes 21s to sync 365 buffers in this case is normal?


      

In response to

pgsql-performance by date

Next:From: Nimesh SatamDate: 2010-10-22 11:14:15
Subject: Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9.
Previous:From: Greg SmithDate: 2010-10-22 04:06:21
Subject: Re: BBU Cache vs. spindles

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