Re: turning fsync off for WAL

Поиск
Список
Период
Сортировка
От Ram Ravichandran
Тема Re: turning fsync off for WAL
Дата
Msg-id c8cd6fbb0806030448w2f93f2bcr836431da4c6b9f52@mail.gmail.com
обсуждение исходный текст
Ответ на Re: turning fsync off for WAL  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-general

Ahh. I think you can use this effectively but not the way you're describing.

Instead of writing the wal directly to persistentFS what I think you're better
off doing is treating persistentFS as your backup storage. Use "Archiving" as
described here to archive the WAL files to persistentFS:

http://postgresql.com.cn/docs/8.3/static/runtime-config-wal.html#GUC-ARCHIVE-MODE

Looks like this is the best solution.

Thanks,

Ram

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: turning fsync off for WAL
Следующее
От: "Ivan Zolotukhin"
Дата:
Сообщение: Re: Cannot drop user (PostgreSQL 8.1.11)