From: Tomasz Ostrowski <tometzky@batory.org.pl>
To: rihad <rihad@mail.ru>
Cc: pgsql-general@postgresql.org
Subject: Re: full_page_writes = off?
Date: Sat, 1 Dec 2007 12:47:57 +0100
Message-ID: <20071201114754.GA2552@batory.org.pl> (raw)
In-Reply-To: <4751150F.8080604@mail.ru>
References: <4751150F.8080604@mail.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tometzky@batory.org.pl, rihad@mail.ru, pgsql-general@postgresql.org
Subject: Re: full_page_writes = off?
In-Reply-To: <20071201114754.GA2552@batory.org.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox