synchronous_commit = off does make a significant difference.
Sure, but I had thought about that and kept this one...
I think I found one possible culprit: I automatically wrote 300 seconds
for checkpoint_timeout, instead of 30 seconds in your settings. I'll have
to rerun the tests with this (unreasonnable) figure to check whether I
really get a regression.
Other tests I ran with "reasonnable" settings on a large (scale=800) db
did not show any significant performance regression, up to know.
--
Fabien.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers