From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Upgrading question (recycled transaction log) |
Date: | 2004-04-09 17:18:12 |
Message-ID: | OF40CC7EEA.D369D474-ON88256E71.005E830B-88256E71.005FE128@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Doing an upgrade from 7.3.6 to 7.4.2 and I keep seeing the recycled
transaction log about every 2 mins. For future upgrades, is there
something that can be set so that I don't have as many recycles? It seems
to slow down the importing of data.
Here's my current settings:
#---------------------------------------------------------------------------
# WRITE AHEAD LOG
#---------------------------------------------------------------------------
# - Settings -
#fsync = true # turns forced synchronization on or off
#wal_sync_method = fsync # the default varies across platforms:
# fsync, fdatasync, open_sync, or
open_datasync
wal_buffers = 32 # min 4, 8KB each
# - Checkpoints -
checkpoint_segments = 30 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 600 # range 30-3600, in seconds
#checkpoint_warning = 30 # 0 is off, in seconds
#commit_delay = 0 # range 0-100000, in microseconds
#commit_siblings = 5 # range 1-1000
TIA
Patrick Hatcher
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-04-09 18:03:27 | Re: Upgrading question (recycled transaction log) |
Previous Message | Tom Lane | 2004-04-09 16:50:35 | Re: plan problem |