From: Leonardo Francalanci <m_lists@yahoo.it>
To: Gael Le Mignot <gael@pilotsystems.net>
To: pgsql-performance@postgresql.org
Subject: Re: Periodically slow inserts
Date: Thu, 21 Oct 2010 14:15:40 +0100 (BST)
Message-ID: <857928.20870.qm@web29002.mail.ird.yahoo.com> (raw)
In-Reply-To: <plop8762wvspfb.fsf@aoskar.kilobug.org>
References: <plop8762wvspfb.fsf@aoskar.kilobug.org>
> We are using PostgreSQL for storing data and full-text search indexes
> for the webiste of a daily newspaper. We are very happy overall with the
> results, but we have one "weird" behaviour that we would like to solve.
I think there's a lot of missing info worth knowing:
1) checkpoints logs? Enable them, maybe the "slowness" happens
at checkpoints:
log_checkpoints=true
2) How many rows does each table contain?
3) HW: how many discs you have, and which controller you're using (and:
does it use a BBU?)
The more you tell the list, the better help you'll get...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: m_lists@yahoo.it, gael@pilotsystems.net
Subject: Re: Periodically slow inserts
In-Reply-To: <857928.20870.qm@web29002.mail.ird.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox