Florian Ledoux wrote:
An autovacuum deamon has been installed as a Windows service during
the setup of my PG 8.0.3 server on WinXP. I am surprised because I
believed that autovacuum was only available in 8.1 server. There is
no autovacuum_XXX parameters in postgresql.conf... How can I be sure
that autovacuum is correctly working ? If it is the case, how is it
configured ?
Can I rely on this service or have I to periodicaly launch vacuumdb instead ?
Can anybody help me...
In Postgresql 7.4 and 8.0 there was a contrib version of autovacuum,
which is the reason it gets installed as a separate service, and also
the reason there are no options for it in the postgresql.conf file. The
Windows installer installs this contrib version by default and most
people find it to be helpful.
Starting with 8.1, autovacuum has be reworked and integrated into the
backend, so it will no longer show up as a separate service, and there
will be options in the Postgresql.conf file.
Did that help?
Matt
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
