From: Gregory Stark <stark@enterprisedb.com>
To: Vinubalaji Gopal <vgopal@abaca.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Pgsql-Performance \(\(E-mail\)\) <pgsql-performance@postgresql.org>
Subject: Re: best way to run maintenance script
Date: Sat, 15 Mar 2008 12:46:04 +0000
Message-ID: <877ig4f94j.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <1205555288.12661.33.camel@vinu-ubuntu.abaca>
References: <1205542821.12661.16.camel@vinu-ubuntu.abaca>
<20080314173235.58f854e6@commandprompt.com>
<1205545912.12661.22.camel@vinu-ubuntu.abaca>
<13414.1205545042@sss.pgh.pa.us>
<1205555288.12661.33.camel@vinu-ubuntu.abaca>
"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!
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: stark@enterprisedb.com, vgopal@abaca.com, tgl@sss.pgh.pa.us, jd@commandprompt.com
Subject: Re: best way to run maintenance script
In-Reply-To: <877ig4f94j.fsf@oxford.xeocode.com>
* 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