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

Re: Another WAL question

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Another WAL question
Date: 2001-09-12 17:32:31
Message-ID: 200109121732.f8CHWVp18785@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
In 7.1.3 and 7.2, there are only 2-3 WAL files kept because there is no
need to keep them after a checkpoint.  Is there any need to have these
WAL config paramaters anymore?

We currently have in postgresql.conf:

#wal_buffers = 8            # min 4
#wal_files = 0 # range 0-64
#wal_sync_method = fsync   # fsync or fdatasync or open_sync or
open_datasync
# Note: default wal_sync_method varies across platforms
#wal_debug = 0             # range 0-16
#commit_delay = 0          # range 0-100000
#commit_siblings = 5       # range 1-1000
#checkpoint_segments = 3   # in logfile segments (16MB each), min 1
#checkpoint_timeout = 300  # in seconds, range 30-3600


> Robert F. mentioned that there is a config parameter controlling the number
> of WAL files in postgresql.conf.
> 
> I just looked at the Doc on this & I found WAL_FILES, which appears to
> specify the number of files to create in advance, but it is no clear to me
> that this limits the total number of WAL files created. Can this number be
> exceeded as needed by the postmaster? If so, is there another parameter that
> I'm missing to set a limit?
> 
> Are old WAL files deleted or re-used automatically when all of their
> contents have been flushed to the DB, or should we be watching these &
> either archiving or deleting old ones?
> 
> TIA,
> 
> -Nick
> 
> ---------------------------------------------------------------------
> Nick Fankhauser
> 
> Business:
> nickf(at)doxpop(dot)com  Phone 1.765.965.7363  Fax 1.765.962.9788
> doxpop  - Court records at your fingertips - http://www.doxpop.com/
> 
> Personal:
> nick(at)fankhausers(dot)com   http://www.fankhausers.com
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-admin by date

Next:From: Nick FankhauserDate: 2001-09-12 17:53:41
Subject: Re: Another WAL question
Previous:From: Robert.FarrugiaDate: 2001-09-12 16:24:18
Subject: Re: Can't get postmaster to restart after removing WAL files

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