Re: full_page_writes = off?

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: full_page_writes = off?
Date: 2007-12-01 11:47:57
Message-ID: 20071201114754.GA2552@batory.org.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

On Sat, 01 Dec 2007, rihad wrote:

> fsync = on;
> synchronous_commit = off;
> full_page_writes = off;
> Thanks for any insights or clarifying missed points.

Also check whether a disks have write-caching turned off - it should.
On Linux the command is:
# hdparm -W /dev/sda
/dev/sda:
write-caching = 0 (off)
I don't know how to check it on BSD.

It can be on for extra performance only if your disks are connected
to battery backed RAID controller.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Martin Marques 2007-12-01 12:04:44 Re: full_page_writes = off?
Previous Message Gregory Stark 2007-12-01 11:37:31 Re: full_page_writes = off?

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2007-12-01 12:04:44 Re: full_page_writes = off?
Previous Message Gregory Stark 2007-12-01 11:37:31 Re: full_page_writes = off?