Re: [PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-16 Thread Bruce McAlister
integer Custom vacuum_freeze_min_age parameter freeze_max_age integer Custom autovacuum_freeze_max_age parameter Thanks Bruce Bruce McAlister [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Tom, Thanks for the suggestion. It's been a while since I replied to this as I

Re: [PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-09 Thread Bruce McAlister
. Thanks Bruce Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Bruce McAlister [EMAIL PROTECTED] writes: [1] AutoVacuum runs during the day over the entire PostgreSQL cluster, Good, but evidently you need to make it more aggressive. [2] A Vacuum Full Verbose is run during our

[PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-05 Thread Bruce McAlister
Hi All, I tried posting this last week but it has not come through yet, so please excuse me if there is a double post. We're having some issue's with the vacuum times within our database environment, and would like some input from the guru's out there that could potentially suggest a better

Re: [PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-05 Thread Bruce McAlister
:39 22M /database/pgsql/bf_service/data 6.7M /database/pgsql/bf_service/index Completed checking disk usage after maintenance on service (sipaccounts) at 02-Mar-2007 03:44:39 Thanks Bruce Heikki Linnakangas [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Bruce McAlister wrote: Over