Re: degenerate performance on one server of 3

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Erik Aronesty <erik(at)q32(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: degenerate performance on one server of 3
Date: 2009-06-01 03:28:51
Message-ID: 4A234AF3.1000907@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:
> Erik Aronesty <erik(at)q32(dot)com> writes:
>> I have 3 servers, all with identical databases, and each performing
>> very differently for the same queries.
>
> I'm betting on varying degrees of table bloat. Have you tried vacuum
> full, cluster, etc?

Or, if you have been using VACUUM FULL, try REINDEXing the tables,
because it could easily be index bloat. Clustering the table will take
care of index bloat as well as table bloat.

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-06-01 03:40:15 Re: degenerate performance on one server of 3
Previous Message Tom Lane 2009-05-31 21:14:59 Re: autovacuum hung?