Hello synchronous_commit = off is well for specific load, try only one connect pgbench ~ it is analogy for database import or some administrator's work. Regards Pavel Stehule On 21/01/2008, Hannes Dorbath <light@xxxxxxxxxxxxxxxxxxxx> wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
