Received: from maia.hub.org (unknown [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 949481337B50 for ; Fri, 22 Oct 2010 04:50:59 -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 60564-04 for ; Fri, 22 Oct 2010 07:50:51 +0000 (UTC) X-Greylist: delayed 00:05:44.23336 by SQLgrey-1.7.6 Received: from nm19.bullet.mail.ukl.yahoo.com (nm19.bullet.mail.ukl.yahoo.com [217.146.183.193]) by mail.postgresql.org (Postfix) with SMTP id 3B98213364DE for ; Fri, 22 Oct 2010 04:50:51 -0300 (ADT) Received: from [217.146.183.210] by nm19.bullet.mail.ukl.yahoo.com with NNFMP; 22 Oct 2010 07:45:06 -0000 Received: from [217.146.183.171] by tm3.bullet.mail.ukl.yahoo.com with NNFMP; 22 Oct 2010 07:45:05 -0000 Received: from [127.0.0.1] by omp1012.mail.ukl.yahoo.com with NNFMP; 22 Oct 2010 07:45:05 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 721242.60184.bm@omp1012.mail.ukl.yahoo.com Received: (qmail 6414 invoked by uid 60001); 22 Oct 2010 07:45:02 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s1024; t=1287733502; bh=/JktvvX5zG9chzq2bB7XqI1+CzDRMbXblCVekR+QmsY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=zh4rn0rOrtcriUlY+Yl0t03Fdhg3ioyh57wGSyOn1sO/T9Z2/0utIeWJbnl80DffUU80veYfbtghZY/8O9aQnIRV0NbjeClpD+EaRKscsuZZMbJHVrOMgqm36CreV4WW1AUocYzSO9uahgCbhayljMLwqDkPWo1PbdR5YdK3BTo= 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:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=l+rAESS2Cl7Imxw3Jn3F7XQ8fNS5QdqoQ31MUEjjqfZ+6DMJTPXWuNwx/TkAKJA/6e6jzpPbEjJ5m/LFf88lRelmWBtQTTqY5eGs6VeAD5W+RUp9MDYRQ9O+pi04bvF/nLZsy+bshDfxnq1XzEGQXljcfDTd/A6mAXUrpQRFXV4=; Message-ID: <191365.6037.qm@web29002.mail.ird.yahoo.com> X-YMail-OSG: 3RnF3cAVM1nl4udXWnnRjZWMN_X1WvKw9951y0MJ0QoeQaW TYD_jCHpm.cfzvK0Pdiuv0BgYHAwDnaVC0mjWEfgccuc.1YGrOM9BLSDDcG_ _JK4LZHhde12l1BqMQf5jJnEV3DT68VydV5sYrYy.29.QvCPtjMoAKGA.gV9 stZgKC3VyzvJsb5xffSb7Tp60fkGz6yneJ099x5jlOXhvfo6d974Llk8- Received: from [85.33.62.89] by web29002.mail.ird.yahoo.com via HTTP; Fri, 22 Oct 2010 08:45:02 BST X-Mailer: YahooMailRC/504.5 YahooMailWebService/0.8.107.284920 References: <23677.1287672948@sss.pgh.pa.us> <25979.1287679800@sss.pgh.pa.us> Date: Fri, 22 Oct 2010 08:45:02 +0100 (BST) From: Leonardo Francalanci Subject: Re: Periodically slow inserts To: Tom Lane , Gael Le Mignot Cc: pgsql-performance@postgresql.org In-Reply-To: <25979.1287679800@sss.pgh.pa.us> 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=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201010/377 X-Sequence-Number: 40795 >>> I think this may be caused by GIN's habit of queuing index insertions= =0A>>> until it's accumulated a reasonable-size batch:=0A=0ASo the fact th= at it takes 21s to sync 365 buffers in this case is normal?=0A=0A=0A