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.