Re: Disable WAL completely

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Disable WAL completely
Дата
Msg-id 20080219154801.GB6148@crankycanuck.ca
обсуждение исходный текст
Ответ на Re: Disable WAL completely  (Matthew <matthew@flymine.org>)
Список pgsql-performance
On Tue, Feb 19, 2008 at 02:48:55PM +0000, Matthew wrote:
> If there's not much write traffic, the WAL won't be used much anyway.

You still have checkpoints.

> If you really don't care much about the integrity, then the best option is
> probably to put the WAL on ramfs.

Um, that will cause the WAL to go away in the event of device crash.  Surely
that's a bad thing?

A


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

Предыдущее
От: Cousin Marc
Дата:
Сообщение: strange plan choice
Следующее
От: Douglas J Hunley
Дата:
Сообщение: 7 hrs for a pg_restore?