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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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