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)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: plan problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Upgrading question (recycled transaction log)