Re: [pgsql-performance] Is dump-reload the only cure?

On Fri, 2002-11-01 at 06:15, mallah@trade-india.com wrote:
> tradein_clients=# VACUUM VERBOSE ANALYZE email_bank_mailing_lists;
> NOTICE:  --Relation email_bank_mailing_lists--
> NOTICE:  Pages 3583: Changed 0, Empty 0; Tup 256419: Vac 0, Keep 0, UnUsed 44822.
>         Total CPU 0.24s/0.04u sec elapsed 0.30 sec.
> NOTICE:  Analyzing email_bank_mailing_lists
> VACUUM

I'd suggest running a vacuum full and then running vacuum analyze more
often.  44822 unused tuples seems quite excessive to me...

Robert Treat