pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
WAL
2+ messages / 2 participants
[nested] [flat]

* WAL
@ 2005-04-25 17:31 Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>
  2005-04-25 17:37 ` Re: WAL Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Dextra - Gustavo Bartz Guedes @ 2005-04-25 17:31 UTC (permalink / raw)
  To: pgsql-admin

Greetings,
Turning of fsync does not mean turn off WAL as well? So why does the 
xlog files (pg_xlog) still being recycled?

I'm using postgresql 8.0.2.

Thanks.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: WAL
  2005-04-25 17:31 WAL Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>
@ 2005-04-25 17:37 ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2005-04-25 17:37 UTC (permalink / raw)
  To: Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-25 17:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-25 17:31 WAL Dextra - Gustavo Bartz Guedes <gustavo-bartz@dextra.com.br>
2005-04-25 17:37 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox