pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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