Re: full_page_writes = off?
| От | Tomasz Ostrowski |
|---|---|
| Тема | Re: full_page_writes = off? |
| Дата | |
| Msg-id | 20071201114754.GA2552@batory.org.pl обсуждение исходный текст |
| Ответ на | full_page_writes = off? (rihad <rihad@mail.ru>) |
| Ответы |
Re: full_page_writes = off?
|
| Список | 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
В списке pgsql-general по дате отправления: