Hello,

We are new about autovacuum launcher on 8.3.1 and we are not sure what the
parameters should be set to. Is setting them to default ok until we can
monitor if it's vacumming too much?

Below are the parameters that we think are the only params we need to do a
basic vacuum and analyze to our entire database.

autovacuum=true
track_counts=ture
log_autovacuum_min_duration=1000ms
autovacuum_max_workers=3(default)
autovacuum_naptime=60
autovacuum_vacuum_threshold=50(default)

Are the above settings all we need to start auto vacuuming?
--
Regards,

Barbara Stephenson
EDI Specialist/Programmer
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30507
tel: (678)989-3020 fax: (404)935-6171
barbara@turbocorp.com
www.ohlogistics.com

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi,

Barbara Stephenson a écrit :
> We are new about autovacuum launcher on 8.3.1 and we are not sure what the
> parameters should be set to. Is setting them to default ok until we can
> monitor if it's vacumming too much?
>

You can do that. But the default are, as always with PostgreSQL, really
conservative. So you'll probably need to change them because it will not
vacuum enough.

> Below are the parameters that we think are the only params we need to do a
> basic vacuum and analyze to our entire database.
>
> autovacuum=true
> track_counts=ture
> log_autovacuum_min_duration=1000ms
> autovacuum_max_workers=3(default)
> autovacuum_naptime=60
> autovacuum_vacuum_threshold=50(default)
>
> Are the above settings all we need to start auto vacuuming?

ISTM you forgot autovacuum_vacuum_scale_factor and the analyze parameters.

Regards.


--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Oh I have to look at the other parameters. Once the database is up and it's
not vacuuming like we want how do we make changes to the conf file while the
database is running? Some signal?

Guillaume Lelarge wrote:
> Hi,
>
> Barbara Stephenson a écrit :
> > We are new about autovacuum launcher on 8.3.1 and we are not sure what
> > the parameters should be set to. Is setting them to default ok until we
> > can monitor if it's vacumming too much?
>
> You can do that. But the default are, as always with PostgreSQL, really
> conservative. So you'll probably need to change them because it will not
> vacuum enough.
>
> > Below are the parameters that we think are the only params we need to do
> > a basic vacuum and analyze to our entire database.
> >
> > autovacuum=true
> > track_counts=ture
> > log_autovacuum_min_duration=1000ms
> > autovacuum_max_workers=3(default)
> > autovacuum_naptime=60
> > autovacuum_vacuum_threshold=50(default)
> >
> > Are the above settings all we need to start auto vacuuming?
>
> ISTM you forgot autovacuum_vacuum_scale_factor and the analyze parameters.
>
> Regards.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com

--
Regards,

Barbara Stephenson
EDI Specialist/Programmer
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30507
tel: (678)989-3020 fax: (404)935-6171
barbara@turbocorp.com
www.ohlogistics.com

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

> Hi,
>
> Barbara Stephenson a écrit :
> > We are new about autovacuum launcher on 8.3.1 and we are not sure what
> the
> > parameters should be set to. Is setting them to default ok until we can
> > monitor if it's vacumming too much?
> >
>
> You can do that. But the default are, as always with PostgreSQL, really
> conservative. So you'll probably need to change them because it will not
> vacuum enough.
>
> > Below are the parameters that we think are the only params we need to do
> a
> > basic vacuum and analyze to our entire database.
> >
> > autovacuum=true
> > track_counts=ture
> > log_autovacuum_min_duration=1000ms
> > autovacuum_max_workers=3(default)
> > autovacuum_naptime=60
> > autovacuum_vacuum_threshold=50(default)
> >
> > Are the above settings all we need to start auto vacuuming?
>
> ISTM you forgot autovacuum_vacuum_scale_factor and the analyze parameters.
>

Are there guides, utilities or web pages published out there that help you determine the optimal settings for these parameters?

How are folks settings these parameters where their product (with PostgreSQL included) is deployed under various customer environments, say 50 different customers?

What improvements are occurring to have the PostgreSQL back-end "auto-tune"these parameters on install or on an ongoing basis?



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin