Re: Perfomance difference between 7.2 and 7.3

Поиск
Список
Период
Сортировка
От Paulo Jan
Тема Re: Perfomance difference between 7.2 and 7.3
Дата
Msg-id 3FB25EDF.2010906@digital.ddnet.es
обсуждение исходный текст
Ответ на Perfomance difference between 7.2 and 7.3  (Paulo Jan <admin@digital.ddnet.es>)
Список pgsql-general
Tom Lane wrote:
> 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,



    Argh!!! The thing is, I *had* run VACUUM several times before posting
to the list... but it was VACUUM ANALYZE, not VACUUM FULL. And here I
was, wondering why VACUUMing so much didn't have any effect...



                    Paulo Jan.
                    DDnet.



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: [HACKERS] Proposal for a cascaded master-slave replication system
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Problem with FKEYS