Обсуждение: Upgrading question (recycled transaction log)

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

"Patrick Hatcher" <PHatcher@macys.com> writes:
> 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?

Increasing checkpoint_segments ... but you seem to have that pretty high
already.

            regards, tom lane