WAL files in 7.2 vs. 7.1

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: WAL files in 7.2 vs. 7.1
Date: 2002-07-05 17:18:22
Message-ID: ag4kbs$1k8s$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have noticed a moderate degradation of performance in our system after
upgrading from 7.1 to 7.2. We are attempting to narrow the list of
culprits (it could be different sizes of critical tables, or any of a
dozen things).

Where the 7.1 installation reports this in the postmaster log:

DEBUG: MoveOfflineLogs: remove 000000A3000000D5

every 10-20 minutes, the 7.2 installation says

DEBUG: recycled transaction log file 00000016000000D1

at about the same frequency. The WAL settings on each database are

wal_files = 2

(and the rest are defaults). Does 7.2's approach of recycling log files
take less time than 7.1's approach of deleting and re-creating? How can
I determine if I have enough WAL files allocated? Should we consider
moving the pg_xlog directory to another physical disk? (At present it
points to a partition on a RAID-striped group of disks.)

--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gregor Mosheh 2002-07-05 17:47:23 Re: memory strangeness (fwd)
Previous Message Stephan Szabo 2002-07-05 16:15:27 Re: Union strange explain