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 по дате отправления: