Re: [GENERAL] Checkpoint Tuning Question

[tomrevam]

Dan Armbrust wrote:
> 
> 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.
> 

Why is the full_page_write happening before the commit returns when
synchronous_commit is set to off? Is there a way to fix this?

Thanks,
Tomer Amiaz
-- 
View this message in context: 
http://www.nabble.com/Checkpoint-Tuning-Question-tp24396082p24607396.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general