DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.it;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=NWo84x+GWwv7VXcyhYWLgxFlWxHfmfIvB959v6bA0B8wYGyhU4VZX8HzWghM2BMhPem/FZGbkUfDEvA+4+GaWa7zUojiXtL8u+fFGxo6e6B1Rwk4qZ2oE/oMeFrhQcShTMpobC2bDm1B89+AAjyoI/azGNlzgKXxkQpZIw5h2qI=;
Message-ID: <857928.20870.qm@web29002.mail.ird.yahoo.com>
References: <plop8762wvspfb.fsf@aoskar.kilobug.org>
Date: Thu, 21 Oct 2010 14:15:40 +0100 (BST)
From: Leonardo Francalanci <m_lists@yahoo.it>
Subject: Re: Periodically slow inserts
To: Gael Le Mignot <gael@pilotsystems.net>, pgsql-performance@postgresql.org
In-Reply-To: <plop8762wvspfb.fsf@aoskar.kilobug.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

 =0A> We are  using PostgreSQL for  storing data and  full-text  search ind=
exes=0A> for the webiste of a daily newspaper. We are  very happy overall w=
ith the=0A> results, but we have one "weird" behaviour that  we would like =
to solve.=0A=0A=0AI think there's a lot of missing info worth knowing:=0A=
=0A1) checkpoints logs? Enable them, maybe the "slowness" happens=0Aat chec=
kpoints:=0A=0Alog_checkpoints=3Dtrue=0A=0A2) How many rows does each table =
contain?=0A=0A3) HW: how many discs you have, and which controller you're u=
sing (and:=0Adoes it use a BBU?)=0A=0AThe more you tell the list, the bette=
r help you'll get...=0A=0A=0A