| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | mallah(at)trade-india(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [pgsql-performance] Is dump-reload the only cure? |
| Date: | 2002-11-01 19:54:05 |
| Message-ID: | 1036180445.20463.22.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
On Fri, 2002-11-01 at 06:15, mallah(at)trade-india(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-11-01 22:28:30 | Re: PostgreSQL Installation on SCO |
| Previous Message | Steve Wolfe | 2002-11-01 18:53:57 | Re: DB Performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wei Weng | 2002-11-01 20:18:01 | Does this matter? |
| Previous Message | mallah | 2002-11-01 14:41:22 | Re: [pgsql-performance] Is dump-reload the only cure? |