From: Michael Holt <michael@aers.ca>
To: pgsql-admin@postgresql.org
Subject: Seems like a large amount of xlog files
Date: Tue, 24 May 2011 16:19:20 -0700
Message-ID: <BANLkTikXWin4_Qct3OSOx6gn2g7GN+8bYA@mail.gmail.com> (raw)
We're trying to do some performance tuning on a couple of postgres boxes and
I've noticed there seems to be a lot of activity in the pg_xlog folder.
There seems to consitently be 132 files with many being written almost every
minute. Looking just now I see 40 written in the last minute and 48 in the
minute before that. I'm having some difficulty determining why there are so
many WAL files being written so frequently as this is normally a
low-write/high read server. There are some things causing implicit
transactions in some old code, but they do not actually write to any tables.
So i have two questions: 1) Does simply running a transaction (implicit or
explicit) cause writing to the WAL? 2) Is there any simple way to track what
may be causing WAL writes?
Alternatively, is there a simple way to see what is being recorded in these
files?
--
*Michael Holt*, *Database Administrator* | A.E.R.S. & TERAPEAK
2307-4464 Markham Street, Victoria, BC, CANADA V8Z 7X8
+1 250 483 3271 (FAX)
www.terapeak.com | www.aers.ca | [image:
facebook]<http://www.facebook.com/pages/Terapeak/21544372056;| [image:
twitter] <http://twitter.com/terapeak;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael@aers.ca
Subject: Re: Seems like a large amount of xlog files
In-Reply-To: <BANLkTikXWin4_Qct3OSOx6gn2g7GN+8bYA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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