From: Steve Crawford <scrawford@pinpointresearch.com>
To: Michael Sawyers <msawyers@iii.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Massive table bloat
Date: Tue, 11 Dec 2012 12:48:26 -0800
Message-ID: <50C79C1A.1080101@pinpointresearch.com> (raw)
In-Reply-To: <1355254890292-5736150.post@n5.nabble.com>
References: <1355242268184-5736111.post@n5.nabble.com>
<CAFwQ8rckXcujW2PqG1raNBExea83PUoTr=SXRARUYYrxRZT7mQ@mail.gmail.com>
<1355254890292-5736150.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 12/11/2012 11:41 AM, Michael Sawyers wrote:
> Political reasons have ruled out the dump and reload options, but restoring
> the entire database took several hours. I'm also restricted on version
> because newer versions of postgres are not supported with that specific
> product, including maintenance updates.
You may want to gently suggest that the powers-that-be start at
http://www.postgresql.org/docs/8.4/static/release-8-4-15.html and work
their way back to
http://www.postgresql.org/docs/8.4/static/release-8-4-2.html compiling a
complete list of data-corrupting, query-wrecking or security-damaging
issues that have been corrected in the over three years since 8.4.1 was
released.
They may also want to look at
http://www.postgresql.org/support/versioning/ - particularly the
statement, "The community considers not upgrading to be riskier than
upgrading."
Ultimately it is their responsibility to make the decision whether or
not to upgrade. It is your responsibility to provide the data necessary
to help them make an informed choice.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, msawyers@iii.com
Subject: Re: Massive table bloat
In-Reply-To: <50C79C1A.1080101@pinpointresearch.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