Re: Low Performance for big hospital server ..

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

In response to

Browse pgsql-performance by date

  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 ..