Re: Perfomance difference between 7.2 and 7.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Perfomance difference between 7.2 and 7.3
Дата
Msg-id 8835.1068651480@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Perfomance difference between 7.2 and 7.3  (Paulo Jan <admin@digital.ddnet.es>)
Список pgsql-general
Paulo Jan <admin@digital.ddnet.es> writes:
>          ->  Seq Scan on todocinetv  (cost=0.00..37768.90 rows=28792
> width=8)

The estimated cost seems to be more than one disk page read per row
returned.  This suggests to me that you have a huge amount of dead space
in that table --- try a VACUUM FULL on it.  If that fixes the problem,
then you need to improve your housekeeping procedures on the 7.2
installation: run vacuums more often and ensure that your FSM settings
are large enough.

            regards, tom lane

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

Предыдущее
От: Paulo Jan
Дата:
Сообщение: Perfomance difference between 7.2 and 7.3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with FKEYS