Skip site navigation (1) Skip section navigation (2)


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dextra - Gustavo Bartz Guedes <gustavo-bartz(at)dextra(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL
Date: 2005-04-25 17:37:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

  • WAL at 2005-04-25 17:31:33 from Dextra - Gustavo Bartz Guedes

pgsql-admin by date

Next:From: Ezequiel TolnayDate: 2005-04-26 02:04:30
Subject: pg_version_history
Previous:From: Dextra - Gustavo Bartz GuedesDate: 2005-04-25 17:31:33
Subject: WAL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group