Postgres Pro
Downloads
Home   >   mailing lists

8.3 synchronous_commit - Mailing list pgsql-performance

From Hannes Dorbath
Subject 8.3 synchronous_commit
Date
Msg-id fn34ca$2ff8$1@news.hub.org
Whole thread Raw
Responses Re: 8.3 synchronous_commit  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: 8.3 synchronous_commit  (Jeff Davis <pgsql@j-davis.com>)
Re: 8.3 synchronous_commit  (Greg Smith <gsmith@gregsmith.com>)
Re: 8.3 synchronous_commit  (Florian Weimer <fweimer@bfk.de>)
List pgsql-performance
Tree view 
I might completely misunderstand this feature. Shouldn't
"synchronous_commit = off" improve performance?

Whatever I do, I find "synchronous_commit = off" to degrade performance.

Especially it doesn't like the CFQ I/O scheduler, it's not so bad with
deadline. Synthetic load like

pgbench -i -s 10 -U pgsql -d bench && pgbench -t 1000 -c 100 -U pgsql -d
bench

or the same with scale 100.

Maybe it's just my test box.. single SATA-II drive, XFS on top of LVM.

I'll retry without LVM once I have another drive.. I've seen LVM mess
with other things in the past.


--
Best regards,
Hannes Dorbath

pgsql-performance by date:

Previous
From: Decibel!
Date:
Subject: Re: strange pauses
Next
From: "Pavel Stehule"
Date:
Subject: Re: 8.3 synchronous_commit