Re: WAL

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: WAL
Дата
Msg-id 200504251737.j3PHboA22494@candle.pha.pa.us
обсуждение исходный текст
Ответ на WAL  (Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>)
Список pgsql-admin
Dextra - Gustavo Bartz Guedes wrote:
> Greetings,
> Turning of fsync does not mean turn off WAL as well? So why does the
> xlog files (pg_xlog) still being recycled?

No, fsync only is used for server crashes.  WAL is still used to recover
from database crashes when the operating system keeps running.  We write
to WAL on commit but not to the file system on commit, and WAL cleans
that up.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Dextra - Gustavo Bartz Guedes
Дата:
Сообщение: WAL
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] PostgreSQL pam ldap document