Re: I/O increase after upgrading to 8.3.5

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alexander Staubo" <alex(at)bengler(dot)no>, "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: I/O increase after upgrading to 8.3.5
Date: 2009-02-13 14:46:42
Message-ID: 49953372.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> Alexander Staubo <alex(at)bengler(dot)no> wrote:
> After upgrading from 8.2 to 8.3.5, the write load on our database
> server has increased dramatically and inexplicably -- as has the CPU
> usage.

Did you do a VACUUM ANALYZE of the database after loading it? Without
the database VACUUM, the first read of any page causes it to be
rewritten to set hint bits. Without an ANALYZE, it might be picking
very inefficient plans. I actually run a VACUUM FREEZE ANALYZE after
loading a database (as with the upgrade), to prevent massive rewrites
of everything in the database at some later date due to freeze
activity.

It could be something else, but I've seen similar behavior for the
above reasons.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alexander Staubo 2009-02-13 15:58:21 Re: I/O increase after upgrading to 8.3.5
Previous Message Matthew Wakeling 2009-02-13 14:45:54 Re: dissimilar drives in Raid10 , does it make difference ?