Postgres Pro
Downloads
Home   >   mailing lists

Re: Checkpoint Tuning Question - Mailing list pgsql-general

From tomrevam
Subject Re: Checkpoint Tuning Question
Date
Msg-id 24607396.post@talk.nabble.com
Whole thread Raw
In response to Re: Checkpoint Tuning Question  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
List pgsql-general
Tree view 


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.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: How would I get information regarding update when running for a long time?
Next
From: Justin Pasher
Date:
Subject: Re: Best practices for moving UTF8 databases