Re: degenerate performance on one server of 3

From: Tom Lane
Subject: Re: degenerate performance on one server of 3
Date: ,
Msg-id: 26562.1243781563@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: degenerate performance on one server of 3  (Erik Aronesty)
Responses: Re: degenerate performance on one server of 3  (Craig Ringer)
List: pgsql-performance

Tree view

degenerate performance on one server of 3  (Erik Aronesty, )
 Re: degenerate performance on one server of 3  (Tom Lane, )
  Re: degenerate performance on one server of 3  (Craig Ringer, )
   Re: degenerate performance on one server of 3  (Tom Lane, )
    Re: degenerate performance on one server of 3  (Erik Aronesty, )
     Re: degenerate performance on one server of 3  (Tom Lane, )
      Re: degenerate performance on one server of 3  (Erik Aronesty, )
       Re: degenerate performance on one server of 3  (Tom Lane, )
       Re: degenerate performance on one server of 3  (Reid Thompson, )
        Re: degenerate performance on one server of 3  (Erik Aronesty, )
         Re: degenerate performance on one server of 3  (Robert Haas, )
          Re: degenerate performance on one server of 3  (Scott Carey, )
         Re: degenerate performance on one server of 3  (Scott Carey, )
          Re: degenerate performance on one server of 3  (Erik Aronesty, )
         Re: degenerate performance on one server of 3  (Robert Haas, )

Erik Aronesty <> 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:

From: Brian Cox
Date:
Subject: Re: autovacuum hung?
From: Tom Lane
Date:
Subject: Re: autovacuum hung?