Re: test commit_delay

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "PG Admin" <pgsql-admin(at)postgresql(dot)org>,"A J" <s5aly(at)yahoo(dot)com>
Subject: Re: test commit_delay
Date: 2011-07-27 17:25:58
Message-ID: 4E3003D6020000250003F821@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

A J <s5aly(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Glyn Astill 2011-07-27 20:22:29 Re: Adding line to pg_hba.conf for a specific group makes superuser authentication fail in 9.0?
Previous Message Kevin Grittner 2011-07-27 16:50:06 Re: Adding line to pg_hba.conf for a specific group makes superuser authentication fail in 9.0?