Alexander Staubo wrote:
On Fri, Feb 13, 2009 at 12:53 PM, Alexander Staubo <alex@xxxxxxxxxx> wrote:
The upgrade was done with dump/restore using "pg_dump -Fc". The old
database lived on a SAN volume, whereas the new database lives on a
local disk volume.
I need to correct myself: The Munin graphs were never set to track the
SAN volume where the old database lived. So when the graph goes from
"near-zero" to "lots", it's actually correct.
When I compare the correct graph, however, it's apparently that I/O
writes have, on average, doubled.
Is there any chance you had pg_xlog stored separately on your old
database, and I/O for it wasn't being recorded?
--
Craig Ringer
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
