Skip site navigation (1) Skip section navigation (2)

"full_page_writes" makes no difference?

From: Tian Luo <jackrobin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "full_page_writes" makes no difference?
Date: 2011-05-04 04:17:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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

But according to the document, when this is off, it could speed up
operations but may cause problems during recovery. So, I guess this is
because it writes less when the option is turned off. However, this
contradicts my observations ....

If I am not missing anything, I find that the writes of log data go
through function "XLogWrite" in source file

In this file, log data are written with the following code:

from = XLogCtl->pages + startidx * (Size) XLOG_BLCKSZ;
nbytes = npages * (Size) XLOG_BLCKSZ;
if (write(openLogFile, from, nbytes) != nbytes)

So, "nbytes" should always be multiples of XLOG_BLCKSZ, which in the
default case, is 8192.

My question is, if it always writes full pages no matter
"full_page_writes" is on or off, what is the difference?


- Tian


pgsql-general by date

Next:From: Jesper KroghDate: 2011-05-04 04:43:20
Subject: Re: [PERFORMANCE] expanding to SAN: which portion best to move
Previous:From: David JohnstonDate: 2011-05-04 04:00:06
Subject: Re: pervasiveness of surrogate (also called synthetic) keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group