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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster