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 <erik@q32.com>)
Ответы Re: degenerate performance on one server of 3
Список pgsql-performance
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 по дате отправления: