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 = '*' port = 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
