pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrading question (recycled transaction log)
2+ messages / 2 participants
[nested] [flat]
* Upgrading question (recycled transaction log)
@ 2004-04-09 17:18 Patrick Hatcher <PHatcher@macys.com>
2004-04-09 18:03 ` Re: Upgrading question (recycled transaction log) Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Patrick Hatcher @ 2004-04-09 17:18 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Upgrading question (recycled transaction log)
2004-04-09 17:18 Upgrading question (recycled transaction log) Patrick Hatcher <PHatcher@macys.com>
@ 2004-04-09 18:03 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-04-09 18:03 UTC (permalink / raw)
To: Patrick Hatcher <PHatcher@macys.com>; +Cc: pgsql-performance
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-09 18:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-09 17:18 Upgrading question (recycled transaction log) Patrick Hatcher <PHatcher@macys.com>
2004-04-09 18:03 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox