From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erik Jones <erik@myemma.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris
Date: Thu, 29 Mar 2007 15:19:49 -0400
Message-ID: <29109.1175195989@sss.pgh.pa.us> (raw)
In-Reply-To: <E49400AB-D46D-4BB8-9F27-65F5AB06F40E@myemma.com>
References: <9B7F4B34-7E96-4501-BCE0-D0BED739530A@myemma.com>
<23286.1175184996@sss.pgh.pa.us>
<E49400AB-D46D-4BB8-9F27-65F5AB06F40E@myemma.com>
Erik Jones <erik@myemma.com> writes:
> One very important thing to note here is that the number, or rather
> rate, of disk writes has not changed. It's the volume of data in
> those writes that has dropped, along with those transaction
> mysterious counts.
Hmm. I'm suddenly thinking about the stats collector: in existing 8.2.x
releases it's got a bug that causes it to write the collected-stats file
much too often. If you had done something that would shrink the size
of the stats file, that might explain this observation. Do you have
stats_reset_on_server_start turned on?
The drop in reported transaction rate is still baffling though. Are you
sure you're really doing the same amount of work? Can you estimate what
you think the transaction rate *should* be from a what-are-your-clients-
doing perspective?
regards, tom lane
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-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, erik@myemma.com
Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris
In-Reply-To: <29109.1175195989@sss.pgh.pa.us>
* 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