pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
test commit_delay
2+ messages / 2 participants
[nested] [flat]

* test commit_delay
@ 2011-07-27 16:33  A J <s5aly@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: A J @ 2011-07-27 16:33 UTC (permalink / raw)
  To: pgsql-admin

I am trying to see the impact of commit_delay.
Set it to 100000 (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 execute a few and measure using the timing command of postgres or the time command 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    0m0.000s
sys     0m0.000s

OR

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


What am I doing wrong ?

Thanks.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: test commit_delay
@ 2011-07-27 17:25  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: A J <s5aly@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Kevin Grittner @ 2011-07-27 17:25 UTC (permalink / raw)
  To: pgsql-admin; A J <s5aly@yahoo.com>

A J <s5aly@yahoo.com> wrote:
 
> Now 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.
 
> What am I doing wrong ?
 
Have you changed commit_siblings from the default of 5?  Do you have
at least commit_siblings other transactions open?
 
-Kevin



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2011-07-27 17:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-07-27 16:33 test commit_delay A J <s5aly@yahoo.com>
2011-07-27 17:25 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>

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