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

From Robert Treat
Subject Re: [pgsql-performance] Is dump-reload the only cure?
Date
Msg-id 1036180445.20463.22.camel@camel
Whole thread Raw
In response to Is dump-reload the only cure?  (<mallah@trade-india.com>)
List pgsql-performance
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




pgsql-performance by date:

Previous
From:
Date:
Subject: Re: Is dump-reload the only cure?
Next
From: Wei Weng
Date:
Subject: Does this matter?