| 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: | Whole Thread | Raw Message | 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 |