Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7AFEBB5D80A for ; Wed, 27 Jul 2011 13:33:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 29053-10 for ; Wed, 27 Jul 2011 16:33:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm27-vm2.bullet.mail.ne1.yahoo.com (nm27-vm2.bullet.mail.ne1.yahoo.com [98.138.91.215]) by mail.postgresql.org (Postfix) with SMTP id A307BB5DBC6 for ; Wed, 27 Jul 2011 13:33:50 -0300 (ADT) Received: from [98.138.90.53] by nm27.bullet.mail.ne1.yahoo.com with NNFMP; 27 Jul 2011 16:33:49 -0000 Received: from [98.138.88.235] by tm6.bullet.mail.ne1.yahoo.com with NNFMP; 27 Jul 2011 16:33:49 -0000 Received: from [127.0.0.1] by omp1035.mail.ne1.yahoo.com with NNFMP; 27 Jul 2011 16:33:49 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 424908.62947.bm@omp1035.mail.ne1.yahoo.com Received: (qmail 6097 invoked by uid 60001); 27 Jul 2011 16:33:49 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1311784429; bh=n3bPyzABddzfSBVh+n8X473Afq6K+/idEU19l0Q2hCs=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=ms/LK8RvGJug3Q8RmO6A07JLKgqmF7a90dAHf+lnv2gAzi0OAMrjdLVs064gcLqFSyz3XyS7jmEt0aXCRMzKdO0l0XxAiWhEn9HXH2eXp1mDo/yYySywAhKPZATN+xDV+5d87ypta9mLfq/No+DeYrnD+AKD9szA0YtdzzFjq2Q= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=XQTuZTx7bF4Hy5JnGCmRWyjWAtetpUhVOY6dYb8oPt7ulsPzzKTvOK6MFSaJC0FjRKiy1dS1tnzA8pHv/g3hYMrKQp2mTuKgxqS0CXm9LalLsW2Ter1caGeQ73evj51tuyrs6Vc36TunE7zcu42H2rTWDJzbbDFjmoj90uMPffw=; X-YMail-OSG: GadDVWgVM1mJBohuc1uCwbtxYWW8sgD8s1KUg4K5Hoh6Qn. Tg9WWH84l8pbwenT6vi4Nh5M354BTyfJH4nn16F9SuNWRURBlbmUYXTOfD0T zk5IwyI9aNsRZ.Mq_HJrI3BI97QveC7SXGpbm5.ZAQJwMbmziKEbk.riM2O5 YmLRv3nPBtCZ5XWNLwTiOOYHujjU5YEsLeFxN9Eyhokf7ml0Bhw0FeeTX1uK 2bVw4846gVvWlwPN5Z4sEkbtig7to4zNccYgMt1jnQvL05I0ZqggX.69kGc7 LHQ6WMOBMUV3GQ_NHOjal4PcgswqCS5DJ8xGhSU6ZIv_XE4LQ3bc- Received: from [64.61.91.74] by web120001.mail.ne1.yahoo.com via HTTP; Wed, 27 Jul 2011 09:33:49 PDT X-Mailer: YahooMailWebService/0.8.112.310352 Message-ID: <1311784429.95728.YahooMailNeo@web120001.mail.ne1.yahoo.com> Date: Wed, 27 Jul 2011 09:33:49 -0700 (PDT) From: A J Reply-To: A J Subject: test commit_delay To: PG Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-518442684-1311784429=:95728" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.11 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-1.193 X-Spam-Level: X-Archive-Number: 201107/193 X-Sequence-Number: 37972 --0-518442684-1311784429=:95728 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I am trying to see the impact of commit_delay.=0ASet it to 100000 (microsec= onds), i.e. to 100ms=0Asynchronous_commit is kept to default (i.e. ON)=0A= =0ANow I expect my DML statements to take atleast 100ms. But when I try to = execute a few and measure using the timing command of postgres or the time = command of linux, the duration is just a few milliseconds.=0Atime /usr/loca= l/pgsql/bin/psql -c "insert into abc values(1);" test=0AINSERT 0 1=0Areal = =A0 =A00m0.010s=0A=0Auser =A0 =A00m0.000s=0Asys =A0 =A0 0m0.000s=0A=0AOR=0A= =0Atest=3D# \timing=0ATiming is on.=0Atest=3D# insert into abc values(1);= =0AINSERT 0 1=0ATime: 2.637 ms=0A=0A=0AWhat am I doing wrong ?=0A=0AThanks.= =0A --0-518442684-1311784429=:95728 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I am = trying to see the impact of commit_delay.
Set it to 10= 0000 (microseconds), i.e. to 100ms
synchronous_commit = is kept to default (i.e. ON)

Now I expect my DML statements to take atleast 100ms. But when I try to ex= ecute a few and measure using the timing command of postgres or the time co= mmand of linux, the duration is just a few milliseconds.
time /usr/local/pgsql/bin/psql -c "insert into abc values(1);" test
INSERT 0 1
real    0m0.010s
user &nbs= p;  0m0.000s
sys     0m0.000s

OR

test=3D# \timing
Timing is on.
test=3D# insert into abc valu= es(1);
INSERT 0 1
= Time: 2.637 ms


What am I doing wrong ?

Thanks.<= /div>

--0-518442684-1311784429=:95728--