Postgres Pro
Downloads
Home   >   mailing lists

Re: degenerate performance on one server of 3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: degenerate performance on one server of 3
Date
Msg-id 26562.1243781563@sss.pgh.pa.us
Whole thread Raw
In response to degenerate performance on one server of 3  (Erik Aronesty <erik@q32.com>)
Responses Re: degenerate performance on one server of 3  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
Tree view 
Erik Aronesty <erik@q32.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?

            regards, tom lane

pgsql-performance by date:

Previous
From: Erik Aronesty
Date:
Subject: degenerate performance on one server of 3
Next
From: Fabrix
Date:
Subject: Re: Scalability in postgres