| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Donald Laurine <Donald(dot)Laurine(at)noaa(dot)gov> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance |
| Date: | 2007-05-23 19:10:11 |
| Message-ID: | 20070523191011.GD5089@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 23, 2007 at 10:12:09AM -0700, Donald Laurine wrote:
> Now my question. The performance of each of these databases is
> decreasing. I measure the average insert time to the database. This
> metric has decreased by about 300 percent over the last year. I run
> vacuum analyze and vacuum analyze full on a daily bases. I also run
> vacuum 4 time a day. Still the performance continues to drop. Are there
> some other performance activities I may try?. Are there other monitoring
> options I can use to indicate where the slow down is occurring?
Forget the VACUUM FULL, it's not worth running that often, it tends to
fragment indexes. At a guess it's probably index fragmentation thats
getting you. Try reindexing some of the larger tables, or just reindex
everything. Also, CLUSTER is better at compacting tables than VACUUM
FULL.
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-05-23 19:10:48 | Re: Remove query results from cache |
| Previous Message | George Pavlov | 2007-05-23 19:04:45 | Re: query log corrupted-looking entries |