Re: best way to run maintenance script - Mailing list pgsql-performance

From Gregory Stark
Subject Re: best way to run maintenance script
Date
Msg-id 877ig4f94j.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: best way to run maintenance script  (Vinubalaji Gopal <vgopal@abaca.com>)
List pgsql-performance
"Vinubalaji Gopal" <vgopal@abaca.com> writes:

> On Fri, 2008-03-14 at 18:37 -0700, Tom Lane wrote:
>> That's only a little bit better.  Read about all the bug fixes you're
>
> Sure - will eventually upgrade it sometime - but it has to wait for
> now :(

Waiting for one of those bugs to bite you is a bad plan.

We're not talking about an upgrade to 8.1, 8.2, or 8.3. We're talking about
taking bug-fixes and security fixes for the release you're already using.

Normally it's just a shutdown and immediate restart. There are exceptions
listed in the 8.0.6 release notes which would require a REINDEX but they don't
affect most people.


--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!

pgsql-performance by date:

Previous
From: Vinubalaji Gopal
Date:
Subject: Re: best way to run maintenance script
Next
From: Justin
Date:
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10