Re: Performance

On May 23, 2007, at 1:12 PM, 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?

I am of the fragmented index camp.  re-index your table that gets the
large number of inserts and deletes.  compare the index sizes before
and after... something like

select relpages,relname from pg_class where relname like 'mybigtable%';

should tell you the sizes.