> So this thought leads to a couple of other things Dan could test. > First, see if turning off full_page_writes makes the hiccup go away. > If so, we know the problem is in this area (though still not exactly > which reason); if not we need another idea. That's not a good permanent > fix though, since it reduces crash safety. The other knobs to > experiment with are synchronous_commit and wal_sync_method. If the > stalls are due to commits waiting for additional xlog to get written, > then async commit should stop them. I'm not sure if changing > wal_sync_method can help, but it'd be worth experimenting with. > > regards, tom lane >
All of my testing to date has been done with synchronous_commit=off I just tried setting full_page_writes=off - and like magic, the entire hiccup went away. Thanks, Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
