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?  (Martin Marques <martin@marquesminen.com.ar>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: full_page_writes = off?
Следующее
От: Martin Marques
Дата:
Сообщение: Re: full_page_writes = off?