Re: Disable WAL completely

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Disable WAL completely
Дата
Msg-id 20080218093240.GA8568@depesz.com
обсуждение исходный текст
Ответ на Re: Disable WAL completely  ("Kathirvel, Jeevanandam" <Jeevanandam.Kathirvel@honeywell.com>)
Ответы Re: Disable WAL completely  (Erik Jones <erik@myemma.com>)
Список pgsql-performance
On Mon, Feb 18, 2008 at 03:00:47PM +0530, Kathirvel, Jeevanandam wrote:
>     Is there way to minimize the I/O operation on disk/CF.
>     Can I create RAM file system and point the pg_xlog files to RAM
> location instead of CF.  whether this will work?

it will, but in case you'll lost power you will also (most probably)
loose your database.

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kathirvel, Jeevanandam"
Дата:
Сообщение: Re: Disable WAL completely
Следующее
От: "Nikolas Everett"
Дата:
Сообщение: Controling where temporary files are created