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,
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