Re: Perfomance difference between 7.2 and 7.3 - Mailing list 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.