autovacuum,8.1, Win

Started by Zlatko Matićover 20 years ago5 messagesgeneral
Jump to latest
#1Zlatko Matić
zlatko.matic1@sb.t-com.hr

What needs to be configured in order autovacuum process be active?

#2Matthew T. O'Connor
matthew@zeut.net
In reply to: Zlatko Matić (#1)
Re: 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

#3Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Zlatko Matić (#1)
Re: autovacuum,8.1, Win

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

#4Wes Williams
wes_williams@fcbonline.net
In reply to: Matthew T. O'Connor (#2)
Re: autovacuum,8.1, Win

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

#5Matthew T. O'Connor
matthew@zeut.net
In reply to: Wes Williams (#4)
Re: autovacuum,8.1, Win

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