09.06.2010 18:29, Scott Marlowe пишет:
> Oh, another question, is this memory usage immediate on startup, or
> does it take time to build up?  If so, how long?  I wonder if the
> slons are trying to output log info, and don't have anywhere to put it
> and it's using up that space or something.  Just a guess.
>
>    

Slon process starting up about 1 sec, i have a log_level=4 in config
We have a usual debug info in log...


Jun 10 09:58:27 vps6147 test_db[8040]: [1-1] 2010-06-10 09:58:27 
MSD[8040] CONFIG main: slon version 2.0.4 starting up
Jun 10 09:58:27 vps6147 test_db[8040]: [2-1] 2010-06-10 09:58:27 
MSD[8040] INFO slon: watchdog process started
Jun 10 09:58:27 vps6147 test_db[8040]: [3-1] 2010-06-10 09:58:27 
MSD[8040] CONFIG slon: watchdog ready - pid = 8040
Jun 10 09:58:27 vps6147 test_db[8041]: [4-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option vac_frequency = 3
Jun 10 09:58:27 vps6147 test_db[8041]: [5-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option log_level = 4
Jun 10 09:58:27 vps6147 test_db[8041]: [6-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option sync_interval = 1000
Jun 10 09:58:27 vps6147 test_db[8041]: [7-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option sync_interval_timeout = 60000
Jun 10 09:58:27 vps6147 test_db[8041]: [8-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option sync_group_maxsize = 20
Jun 10 09:58:27 vps6147 test_db[8041]: [9-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option desired_sync_time = 60000
Jun 10 09:58:27 vps6147 test_db[8040]: [4-1] 2010-06-10 09:58:27 
MSD[8040] CONFIG slon: worker process created - pid = 8041
Jun 10 09:58:27 vps6147 test_db[8041]: [10-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option syslog = 2
Jun 10 09:58:27 vps6147 test_db[8041]: [11-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option quit_sync_provider = 0
Jun 10 09:58:27 vps6147 test_db[8041]: [12-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option quit_sync_finalsync = 0
Jun 10 09:58:27 vps6147 test_db[8041]: [13-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option sync_max_rowsize = 8192
Jun 10 09:58:27 vps6147 test_db[8041]: [14-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option sync_max_largemem = 5242880
Jun 10 09:58:27 vps6147 test_db[8041]: [15-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Integer option remote_listen_timeout = 300
Jun 10 09:58:27 vps6147 test_db[8041]: [16-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Boolean option log_pid = 1
Jun 10 09:58:27 vps6147 test_db[8041]: [17-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Boolean option log_timestamp = 1
Jun 10 09:58:27 vps6147 test_db[8041]: [18-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Boolean option cleanup_deletelogs = 0
Jun 10 09:58:27 vps6147 test_db[8041]: [19-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: Real option real_placeholder = 0.000000
Jun 10 09:58:27 vps6147 test_db[8041]: [20-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option cluster_name = test_db
Jun 10 09:58:27 vps6147 test_db[8041]: [21-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option conn_info = host=localhost 
port=5432 user=postgres password=123
Jun 10 09:58:27 vps6147 test_db[8041]: [21-2] dbname=test_db
Jun 10 09:58:27 vps6147 test_db[8041]: [22-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option pid_file = /var/run/slony1/test_db.pid
Jun 10 09:58:27 vps6147 test_db[8041]: [23-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option log_timestamp_format = %Y-%m-%d 
%H:%M:%S %Z
Jun 10 09:58:27 vps6147 test_db[8041]: [24-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option archive_dir = [NULL]
Jun 10 09:58:27 vps6147 test_db[8041]: [25-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option sql_on_connection = [NULL]
Jun 10 09:58:27 vps6147 test_db[8041]: [26-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option lag_interval = [NULL]
Jun 10 09:58:27 vps6147 test_db[8041]: [27-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option command_on_logarchive = [NULL]
Jun 10 09:58:27 vps6147 test_db[8041]: [28-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option syslog_facility = LOCAL3
Jun 10 09:58:27 vps6147 test_db[8041]: [29-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option syslog_ident = test_db
Jun 10 09:58:27 vps6147 test_db[8041]: [30-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: String option cleanup_interval = 10 minutes
Jun 10 09:58:27 vps6147 test_db[8041]: [31-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: local node id = 1
Jun 10 09:58:27 vps6147 test_db[8041]: [32-1] 2010-06-10 09:58:27 
MSD[8041] INFO main: main process started
Jun 10 09:58:27 vps6147 test_db[8041]: [33-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: launching sched_start_mainloop
Jun 10 09:58:27 vps6147 test_db[8041]: [34-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: loading current cluster configuration
Jun 10 09:58:27 vps6147 test_db[8041]: [35-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG storeSet: set_id=1 set_origin=1 set_comment='Set 1 for 
test_db'
Jun 10 09:58:27 vps6147 test_db[8041]: [37-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: last local event sequence = 5000000023
Jun 10 09:58:27 vps6147 test_db[8041]: [38-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG main: configuration complete - starting threads
Jun 10 09:58:27 vps6147 test_db[8041]: [39-1] 2010-06-10 09:58:27 
MSD[8041] INFO localListenThread: thread starts
Jun 10 09:58:27 vps6147 test_db[8041]: [40-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG version for "host=localhost port=5432 user=postgres 
password=123
Jun 10 09:58:27 vps6147 test_db[8041]: [40-2] dbname=test_db" is 80403
Jun 10 09:58:27 vps6147 test_db[8041]: [42-1] 2010-06-10 09:58:27 
MSD[8041] INFO main: running scheduler mainloop
Jun 10 09:58:27 vps6147 test_db[8041]: [43-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG cleanupThread: thread starts
Jun 10 09:58:27 vps6147 test_db[8041]: [44-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG cleanupThread: bias = 14563
Jun 10 09:58:27 vps6147 test_db[8041]: [45-1] 2010-06-10 09:58:27 
MSD[8041] INFO syncThread: thread starts
Jun 10 09:58:27 vps6147 test_db[8041]: [46-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG version for "host=localhost port=5432 user=postgres 
password=123
Jun 10 09:58:27 vps6147 test_db[8041]: [46-2] dbname=test_db" is 80403
Jun 10 09:58:27 vps6147 test_db[8041]: [48-1] 2010-06-10 09:58:27 
MSD[8041] CONFIG version for "host=localhost port=5432 user=postgres 
password=123
Jun 10 09:58:27 vps6147 test_db[8041]: [48-2] dbname=test_db" is 80403
Jun 10 10:09:54 vps6147 test_db[8041]: [63-1] 2010-06-10 10:09:54 
MSD[8041] INFO cleanupThread: 0.046 seconds for cleanupEvent()
~