synchronous_commit=off doesn't always return immediately - Mailing list pgsql-general

From tomrevam
Subject synchronous_commit=off doesn't always return immediately
Date
Msg-id 24621119.post@talk.nabble.com
Whole thread Raw
Responses Re: synchronous_commit=off doesn't always return immediately
Re: synchronous_commit=off doesn't always return immediately
List pgsql-general
Hi,

I set synchronous_commit to off and expected trivial inserts (single row,
6-8 columns) to always return quickly. However, I see that during
checkpoints they sometimes take over a second. I tried setting the
full_page_write to off, but this didn't seem to have an effect.

The version I'm using is 8.3.3
The configuration is:
bgwriter_delay = 20ms                   # 10-10000ms between rounds
bgwriter_lru_maxpages = 1000            # 0-1000 max buffers written/round
bgwriter_lru_multiplier = 5.0           # 0-10.0 multipler on buffers
scanned/round
synchronous_commit = off                # immediate fsync at commit
full_page_writes = off                  # recover from partial page writes
checkpoint_segments = 32                # in logfile segments, min 1, 16MB
each
checkpoint_timeout = 30min              # range 30s-1h
checkpoint_completion_target = 0.9      # checkpoint target duration, 0.0 -
1.0
checkpoint_warning = 30s                # 0 is off

Thanks,
Tomer
--
View this message in context:
http://www.nabble.com/synchronous_commit%3Doff-doesn%27t-always-return-immediately-tp24621119p24621119.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: 8.4.0 installer for Windows from EnterpriseDB does not seem to include pgagent
Next
From: "Massa, Harald Armin"
Date:
Subject: PostgreSQL 8.4.0-1 windwos crashes when run without admin privs