Re: Upgrading question (recycled transaction log)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Upgrading question (recycled transaction log)
Date: 2004-04-09 18:03:27
Message-ID: 27368.1081533807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Patrick Hatcher" <PHatcher(at)macys(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2004-04-09 19:34:44 Re: [PERFORM] Raw devices vs. Filesystems
Previous Message Patrick Hatcher 2004-04-09 17:18:12 Upgrading question (recycled transaction log)