| From: | Mike Mascari <mascarm(at)mascari(dot)com> |
|---|---|
| To: | William Yu <wyu(at)talisys(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Low Performance for big hospital server .. |
| Date: | 2005-01-03 08:51:42 |
| Message-ID: | 41D9079E.5020104@mascari.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
William Yu wrote:
> amrit(at)health2(dot)moph(dot)go(dot)th wrote:
>> Yes , vacuumdb daily.
>
> Do you vacuum table by table or the entire DB? I find over time, the
> system tables can get very bloated and cause a lot of slowdowns just due
> to schema queries/updates. You might want to try a VACUUM FULL ANALYZE
> just on the system tables.
A REINDEX of the system tables in stand-alone mode might also be in
order, even for a 7.4.x database:
http://www.postgresql.org/docs/7.4/interactive/sql-reindex.html
If a dump-reload-analyze cycle yields significant performance
improvements then we know it's due to dead-tuple bloat - either heap
tuples or index tuples.
Mike Mascari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory S. Williamson | 2005-01-03 09:32:45 | Re: Low Performance for big hospital server .. |
| Previous Message | William Yu | 2005-01-03 08:32:10 | Re: Low Performance for big hospital server .. |