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
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? |
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? |