Upgrading question (recycled transaction log)
От | Patrick Hatcher |
---|---|
Тема | Upgrading question (recycled transaction log) |
Дата | |
Msg-id | OF40CC7EEA.D369D474-ON88256E71.005E830B-88256E71.005FE128@fds.com обсуждение исходный текст |
Ответы |
Re: Upgrading question (recycled transaction log)
|
Список | 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
В списке pgsql-performance по дате отправления: