Received: from maia.hub.org (unknown [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 60C751337B47 for ; Thu, 21 Oct 2010 12:30:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 26291-03 for ; Thu, 21 Oct 2010 15:30:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web29012.mail.ird.yahoo.com (web29012.mail.ird.yahoo.com [212.82.110.153]) by mail.postgresql.org (Postfix) with SMTP id 5EAA7133655C for ; Thu, 21 Oct 2010 12:30:19 -0300 (ADT) Received: (qmail 4064 invoked by uid 60001); 21 Oct 2010 15:30:18 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s1024; t=1287675018; bh=nr0y6G51UX5DRRS5GXGIjVbV35u6aIN54PPrESJy8gk=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Orw6W48iMFBZTFfyTOtmLP2aXFvxyUJtA5qXnNHrYwRWqXnotBzAd9sw05nmsp17oMR1Jqwv/+O7/E7QHTf/g8v/ydwmpV92zdxLDjKpeyBCfEJtrH+E6ZDl5aYmK+OFt5xgdhpdC3zfRyeC8TOoH24+EOcFu3COBUrvkpiLA2o= 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:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=okEDXapcMrFMRYPFK+KYW1RRXOcDjURHVJ5IXZM/k/IlWj67xSLNQJr0iy17Hj9dNhrBn1kfrcOp5DRGQGDVpWsN9MMNHA2jJQIZvSu9eKcD+3Rsi6mMz7/B6gFUkTUSuHNxEABmWdY5MvPCyp4lUihaldzNopNUQP+Tgg6xqnw=; Message-ID: <219937.1152.qm@web29012.mail.ird.yahoo.com> X-YMail-OSG: .VLNdqEVM1mjTQ8Lsy0gUWnU_UsUP.6u5LZxGbrcAJO9X4B 72VbcSEPovWlKiAmn591SPJPGYuYZ__3bBkQv0JAi7FP9IbXdeq8SCTPrlE0 ajPQtwwgQ6Xv7Iw1Lb3DefJLN3GPJdd0UGv6x4dPc7K46fGqH.Px74dnIdki F8W521riBzRhMN09AafKUBfjBKaJAYFAH1wZrTabZOmBDykvs2yWB2eM- Received: from [85.33.62.89] by web29012.mail.ird.yahoo.com via HTTP; Thu, 21 Oct 2010 16:30:15 BST X-Mailer: YahooMailRC/504.5 YahooMailWebService/0.8.106.282862 References: <857928.20870.qm@web29002.mail.ird.yahoo.com> Date: Thu, 21 Oct 2010 16:30:15 +0100 (BST) From: Leonardo Francalanci Subject: Re: Periodically slow inserts Cc: Gael Le Mignot , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.879 tagged_above=-10 required=5 tests=BAYES_00=-1.9, MISSING_HEADERS=1.021 X-Spam-Level: X-Archive-Number: 201010/347 X-Sequence-Number: 40765 > 2010-10-21 16:39:15 CEST LOG: checkpoint complete: wrote 365 buffers=0A= > (11.9%); 0 transaction log file(s) added, 0 removed, 3 recycled;=0A> wri= te=3D0.403 s, sync=3D21.312 s, total=3D21.829 s=0A=0A=0AI'm no expert, but= isn't 21s to sync 365 buffers a big amount of time?=0A=0A=0A=0A