> The Vacuum's don't take too long, 10 minutes at most. I can tell from ps
> -ef | grep and top that its the selects/inserts/updates from the postgres
> related to our app that take all that time up. If we rerun initdb and
> reload the data, it works great for about two days, then goes bad again.
> We are in the process of trying out 7.4.2 right now, just waiting on the
> reload of pg_dump.
Well, test running VACUUM ANALYZE as the "postgres" superuser and see if that
fixes the issue.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Jaime Casanova||Date: 2004-03-29 21:56:10|
|Subject: Re: [ADMIN] Raw vs Filesystem|
|Previous:||From: Fabio Esposito||Date: 2004-03-29 19:36:24|
|Subject: Re: postgres eating CPU on HP9000|