On Wed, 12 Mar 2003 14:38:11 -0800, Max Baker <max@warped.org> wrote:
> -> Seq Scan on node (cost=0.00..107737.61 rows=35561
> width=6) (actual time=6.73..44383.57 rows=34597 loops=1)
35000 tuples in 100000 pages?
>I run VACCUUM ANALYZE once a day.
Try VACUUM FULL VERBOSE ANALAYZE; this should bring back your table
to a reasonable size. If the table starts growing again, VACUUM more
often.
Servus
Manfred