Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading question (recycled transaction log) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Upgrading question (recycled transaction log)
Date
Msg-id 27368.1081533807@sss.pgh.pa.us
Whole thread Raw
In response to Upgrading question (recycled transaction log)  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Upgrading question (recycled transaction log)
Next
From: Josh Berkus
Date:
Subject: Performance data for OpenFTS?