Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > [Postgresql 8.2...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 16 Topic 15976 of 16554
Post > Topic >>

[Postgresql 8.2.3] autovacuum starting up even after disabling ?

by dushyanth@[EMAIL PROTECTED] (Dushyanth) Jul 4, 2008 at 02:51 PM

Hey all,

Iam using PostgreSQL 8.2.3 on RHEL4 (Linux 2.6.20.3-custom #4 SMP x86_64
x86_64
x86_64 GNU/Linux). 

I have autovacuum tunrned off in the config, but it still seems to start
up once
everyday. What could be the cause of this ?

TIA
Dushyanth

$ psql -U postgres
postgres=# show autovacuum;
 autovacuum
------------
 off
(1 row)

$ grep autovacuum postgresql.conf

#autovacuum = off                       
#autovacuum_naptime = 60                
#autovacuum_vacuum_threshold = 1000     
#autovacuum_analyze_threshold = 500     
#autovacuum_vacuum_scale_factor = 0.4   
#autovacuum_analyze_scale_factor = 0.2  
#autovacuum_vacuum_cost_delay = -1      
#autovacuum_vacuum_cost_limit = -1 

# autovacuum processes

postgres 16508  9.2  0.1 2310836 37984 ?     Ds   09:58   0:09  \_
postgres:
autovacuum process   db1
postgres 19626  7.2  0.0 2289524 27704 ?     Ds   10:09   0:03  \_
postgres:
autovacuum process   db1
postgres 20861  7.8  0.0 2298844 31028 ?     Ds   10:13   0:08  \_
postgres:
autovacuum process   db1
postgres 21673  6.1  0.1 2336904 33400 ?     Ds   10:16   0:12  \_
postgres:
autovacuum process   db1
postgres 21673  6.2  0.1 2339840 57400 ?     Ds   10:16   0:31  \_
postgres:
autovacuum process   db1
postgres 13597 11.6  0.0 2358352 29936 ?     Ds   17:12   0:20  \_
postgres:
autovacuum process   db2
postgres 13597  8.7  0.1 2358352 39056 ?     Ds   17:12   0:41  \_
postgres:
autovacuum process   db2
postgres 13597  7.8  0.1 2363924 45540 ?     Ds   17:12   1:01  \_
postgres:
autovacuum process   db2 


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 16 Posts in Topic:
[Postgresql 8.2.3] autovacuum starting up even after disabling ?
dushyanth@[EMAIL PROTECTE  2008-07-04 14:51:23 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
aklaver@[EMAIL PROTECTED]  2008-07-04 08:23:10 
Re: [Postgresql 8.2.3] autovacuum starting up even after
alvherre@[EMAIL PROTECTED  2008-07-04 13:35:43 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
dushyanth@[EMAIL PROTECTE  2008-07-04 23:46:34 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
tgl@[EMAIL PROTECTED] (T  2008-07-05 11:03:44 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
dushyanth@[EMAIL PROTECTE  2008-07-07 08:53:24 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
tgl@[EMAIL PROTECTED] (T  2008-07-07 10:20:51 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
dushyanth@[EMAIL PROTECTE  2008-07-07 16:49:06 
Re: [Postgresql 8.2.3] autovacuum starting up even after
alvherre@[EMAIL PROTECTED  2008-07-07 14:13:53 
Re: [Postgresql 8.2.3] autovacuum starting up even =?utf-8?b?YWZ
dushyanth@[EMAIL PROTECTE  2008-07-21 13:57:13 
Re: [Postgresql 8.2.3] autovacuum starting up even =?utf-8?b?YWZ
dushyanth@[EMAIL PROTECTE  2008-08-12 06:27:48 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
tgl@[EMAIL PROTECTED] (T  2008-07-07 14:30:21 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
dushyanth@[EMAIL PROTECTE  2008-07-08 08:30:26 
Re: [Postgresql 8.2.3] autovacuum starting up even after disabli
dushyanth@[EMAIL PROTECTE  2008-07-04 23:51:47 
Re: [Postgresql 8.2.3] autovacuum starting up even after
alvherre@[EMAIL PROTECTED  2008-07-04 15:10:32 
Re: [Postgresql 8.2.3] autovacuum starting up even after
dushyanth@[EMAIL PROTECTE  2008-07-05 01:53:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Sep 6 22:55:18 CDT 2008.