Greg Smith-12 wrote: > > On Thu, 23 Jul 2009, tomrevam wrote: > >> 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 > > These settings may be contributing to the problem. You should never run > the background writer that frequently--it just wastes resources and writes > more than it should. I'd suggest turning it off altogether > (bgwriter_lru_maxpages = 0) and seeing if things improve any, just to rule > that out as a potential source of issues. > > The behavior of the system is the same with bg_writer_lru_maxpages = 0. Can you explain why transactions are sometimes synchronous even with the synchrounous_commit set to off? Thanks, Tomer -- View this message in context: http://www.nabble.com/synchronous_commit%3Doff-doesn%27t-always-return-immediately-tp24621119p24666816.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
