pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgrading 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>
  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 18:03  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Patrick Hatcher <PHatcher@macys.com>
  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