On Fri, 2002-11-01 at 06:15, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
