Re: degenerate performance on one server of 3

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

Index bloat wouldn't explain the slow-seqscan behavior the OP was
complaining of.  Still, you're right that if the tables are bloated
then their indexes probably are too ... and that VACUUM FULL alone
will not fix that.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: S Arvind
Дата:
Сообщение: Vacuuming technique doubt
Следующее
От: Shaul Dar
Дата:
Сообщение: Postgresql cache (memory) performance + how to warm up the cache