Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id BE9452E0376
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 15 Mar 2008 09:46:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 82284-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sat, 15 Mar 2008 09:46:02 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from oxford.xeocode.com (unknown [87.127.95.194])
	by postgresql.org (Postfix) with ESMTP id 729132E022D
	for <pgsql-performance@postgresql.org>;
	Sat, 15 Mar 2008 09:46:10 -0300 (ADT)
Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com)
	by oxford.xeocode.com with esmtp (Exim 4.69)
	(envelope-from <stark@enterprisedb.com>)
	id 1JaVm1-0004nd-3q; Sat, 15 Mar 2008 12:46:05 +0000
To: "Vinubalaji Gopal" <vgopal@abaca.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Joshua D. Drake" <jd@commandprompt.com>,
	"Pgsql-Performance \(\(E-mail\)\)" <pgsql-performance@postgresql.org>
Subject: Re: best way to run maintenance script
In-Reply-To: <1205555288.12661.33.camel@vinu-ubuntu.abaca> (Vinubalaji Gopal's
	message of "Fri\, 14 Mar 2008 20\:28\:08 -0800")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.performance" 4789)
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>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Sat, 15 Mar 2008 12:46:04 +0000
Message-ID: <877ig4f94j.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/328
X-Sequence-Number: 29282

"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!