Upgrading question (recycled transaction log)

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

Responses

Browse pgsql-performance by date

  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