Re: degenerate performance on one server of 3

Список
Период
Сортировка
От Tom Lane
Тема Re: degenerate performance on one server of 3
Дата
Msg-id 26562.1243781563@sss.pgh.pa.us
обсуждение исходный текст
Ответ на degenerate performance on one server of 3  (Erik Aronesty)
Ответы Re: degenerate performance on one server of 3  (Craig Ringer)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Brian Cox
Дата:
Сообщение: Re: autovacuum hung?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum hung?