Re: test commit_delay - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: test commit_delay
Date
Msg-id 4E3003D6020000250003F821@gw.wicourts.gov
Whole thread Raw
In response to test commit_delay  (A J <s5aly@yahoo.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Adding line to pg_hba.conf for a specific group makes superuser authentication fail in 9.0?
Next
From: Glyn Astill
Date:
Subject: Re: Adding line to pg_hba.conf for a specific group makes superuser authentication fail in 9.0?