From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Paul Lathrop <plathrop@squaretrade.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Defining performance.
Date: Thu, 30 Nov 2006 18:43:54 -0600
Message-ID: <1164933833.14565.320.camel@state.g2switchworks.com> (raw)
In-Reply-To: <8312.1164932796@sss.pgh.pa.us>
References: <456F624F.2090906@squaretrade.com>
<8312.1164932796@sss.pgh.pa.us>
On Thu, 2006-11-30 at 18:26, Tom Lane wrote:
> Paul Lathrop <plathrop@squaretrade.com> writes:
> > ... When I joined the company last year, the databases were
> > deployed on 12-disk RAID5 arrays on dual-proc AMD machines with 4Gb of
> > RAM, running Debian Woody and Postgres 7.2. These systems seemed to
> > suffer a gradually decreasing performance accompanied by a gradually
> > growing disk space usage. The DBA had come to the conclusion that the
> > VACUUM command did/does not work on these systems, because even after a
> > VACUUM FULL, the size of the database was continually increasing.
>
> The very first thing you need to do is get off 7.2.
>
> After that, I'd recommend looking at *not* using VACUUM FULL. FULL is
> actually counterproductive in a lot of scenarios, because it shrinks the
> tables at the price of bloating the indexes. And 7.2's poor ability to
> reuse index space turns that into a double whammy. Have you checked
> into the relative sizes of tables and indexes and tracked the trend over
> time?
And if you cant get off 7.2, look into scheduling some downtime to run
reindex on the bloated indexes.
In all honesty, a simple single processor workstation with a gig of ram
and a couple of good sized SATA drives and a modern linux distro can
probably outrun your 7.2 server if it's running on 8.1 / 8.2
It's that much faster now.
For the love of all that's holy, as well as your data, start planning
your migration now, and if you can, have it done by the end of next week
or so.
And backup every night religiously.
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: smarlowe@g2switchworks.com, tgl@sss.pgh.pa.us, plathrop@squaretrade.com
Subject: Re: Defining performance.
In-Reply-To: <1164933833.14565.320.camel@state.g2switchworks.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