Re: I/O increase after upgrading to 8.3.5 - Mailing list pgsql-performance

From Alexander Staubo
Subject Re: I/O increase after upgrading to 8.3.5
Date
Msg-id 88daf38c0902130804q43ae5f96h9cd418f134d9f439@mail.gmail.com
Whole thread Raw
In response to I/O increase after upgrading to 8.3.5  (Alexander Staubo <alex@bengler.no>)
Responses Re: I/O increase after upgrading to 8.3.5  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: I/O increase after upgrading to 8.3.5  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
On Fri, Feb 13, 2009 at 12:53 PM, Alexander Staubo <alex@bengler.no> 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.

The new volume uses the same file system and block size as the old one.

Alexander.

pgsql-performance by date:

Previous
From: Alexander Staubo
Date:
Subject: Re: I/O increase after upgrading to 8.3.5
Next
From: "Kevin Grittner"
Date:
Subject: Re: I/O increase after upgrading to 8.3.5