Обсуждение: autovacuum,8.1, Win
What needs to be configured in order autovacuum process be active?
On Tue, Nov 08, 2005 at 10:50:53AM +0100, Zlatko Mati? wrote: > What needs to be configured in order autovacuum process be active? http://www.postgresql.org/docs/8.1/interactive/runtime-config-autovacuum.html -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Zlatko Matić wrote: > What needs to be configured in order autovacuum process be active? I assume you are talking about the Windows version. If so, and if you used the installer, then you don't need to do anything. It appears (at least on my RC1 install) that autovacuum is enabled by default. Matt
Correct, the default setting for PostgreSQL 8.1 W32 value in postgresql.conf is 'autovacuum' to 'on'. You can see this and more settings in pgAdmin III by visiting 'Tools', 'Server Configuration', then the config file of your choice. Now, if only I could setup my home to autovaccum. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Matthew T. O'Connor Sent: Tuesday, November 08, 2005 12:05 PM To: Zlatko Matić Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] autovacuum,8.1, Win Zlatko Matić wrote: > What needs to be configured in order autovacuum process be active? I assume you are talking about the Windows version. If so, and if you used the installer, then you don't need to do anything. It appears (at least on my RC1 install) that autovacuum is enabled by default. Matt ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
Wes Williams wrote: > Correct, the default setting for PostgreSQL 8.1 W32 value in postgresql.conf > is 'autovacuum' to 'on'. > > You can see this and more settings in pgAdmin III by visiting 'Tools', > 'Server Configuration', then the config file of your choice. > > Now, if only I could setup my home to autovaccum. Sounds like what you need is a roomba: http://www.irobot.com/sp.cfm?pageid=122