Re: "full_page_writes" makes no difference?

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: "full_page_writes" makes no difference?
Дата
Msg-id BANLkTi=+uiu+9azsynerA=EcwZtUkT80SQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "full_page_writes" makes no difference?  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Список pgsql-hackers


On Wed, May 4, 2011 at 5:46 PM, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:


On Wed, May 4, 2011 at 7:16 AM, Tian Luo <jackrobin@gmail.com> wrote:
Hi guys,

No matter I turn on or turn off the "full_page_writes", I always
observe 8192-byte writes of log data for simple write operations
(write/update).


Not sure how you measured it, but ISTM that the correct GUC to play with is "fsync". If thats turned off, the WAL buffers won't be fsynced to the disk at every commit. But that would mean reduced reliability in case of database crash.



And I should have added that post 8.3, we also have a user-settable parameter called synchronous_commit. Normally, database must write WAL up to the commit record to the stable storage when a transaction commits to ensure that there is no data loss in case of database crash. But if synchronous_commit is turned off, the database might delay writing the WAL buffers to the disk, thus reducing write activity, but at a increased risk of data loss.


Thanks,
Pavan 

--
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Re: "full_page_writes" makes no difference?
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: branching for 9.2devel