Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?

Hi,

Tom Lane <tgl <at> sss.pgh.pa.us> writes:
> dushy <dushyanth <at> gmail.com> writes:
> > On Fri, Jul 4, 2008 at 10:56 PM, Adrian Klaver <aklaver <at>
comcast.net> 
wrote:
> >> One question? Did you do pg_ctl reload after changing the config
file?
> 
> > I did not change any config yet - autovacuum was always disabled since
> > the day PG was set up.
> 
> A mistake here seems by far the most likely explanation. 

I have rechecked the config multiple times till now :)

> Does "show autovacuum" confirm that it's off?

Yes.

# show autovacuum;
 autovacuum
------------
 off
(1 row)

# Below pocess tree is from todays process logs (i just logged `ps fax`
output
every 5 mts to a file)

postgres  8951  0.0  0.1 2270284 60484 ?     S    Jun29   0:53
/usr/local/postgres/pgsql-8.2.3/bin/postgres -D /usr/local/p
ostgres/current/data -i
postgres  8989  4.8  0.0 57496  948 ?        Ss   Jun29 547:03  \_
postgres:
logger process
postgres  9002  0.0  6.4 2271532 2127764 ?   Ss   Jun29   4:06  \_
postgres:
writer process
postgres  9003  0.0  0.0 58564 1024 ?        Ss   Jun29   0:02  \_
postgres:
archiver process
postgres  9004  0.0  0.0 58448  832 ?        Ss   Jun29   0:00  \_
postgres:
stats collector process
postgres 10259  3.7  3.4 2293908 1143908 ?   Ds   07:06   3:18  \_
postgres:
autovacuum process   dbname

# complete postgresql.conf

listen_addresses = '*'
****t = 5432
max_connections = 1200
superuser_reserved_connections = 5
shared_buffers = 262143
work_mem =  49152
max_fsm_pages = 6000000
checkpoint_segments = 9
archive_command = '/usr/local/postgres/WALLogs/copy_to_archive.sh %p %f'
effective_cache_size = 2752512
random_page_cost = 2.5
default_statistics_target = 50
log_destination = 'stderr'
redirect_stderr = true
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_rotation_size = 256000
log_connections = on
log_disconnections = on
log_duration = on
log_line_prefix = '%t [%p]: [%l-1] '
log_statement = 'all'
stats_start_collector = on
stats_command_string = on
statement_timeout = 120000
deadlock_timeout = 1000
add_missing_from = on



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