Tom Lane wrote:
> Paulo Jan <admin(at)digital(dot)ddnet(dot)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.