Re: [PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-16 Thread Bruce McAlister
eter freeze_min_age 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 sug

Re: [PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-09 Thread Bruce McAlister
l for any and all suggestions/comments. 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, > > Go

Re: [PERFORM] PostgreSQL 8.2.3 VACUUM Timings/Performance

2007-03-05 Thread Bruce McAlister
-Mar-2007 03:44: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 PR

[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 ap