i build slony1-1.2.21 RPM for the i686 architecture with postgresql8.4-server-8.4.4, create test vps with the same linux distributive (but i686 arch..)
It's amazing but, the same test db... [r...@vps999 /]# ps auxf |grep slon root 15397 0.0 0.0 1880 524 pts/0 S+ 07:58 0:00 \_ grep slon postgres 26415 0.0 0.0 5304 1376 pts/0 S 07:50 0:00 /usr/bin/slon postgres 26417 0.0 0.0 46448 1296 pts/0 Sl 07:50 0:00 \_ /usr/bin/slon [r...@vps999 /]# VMZ 46mb.... it's wonderful another experiment... slony1-1.2.21 with postgresql8.4-server-8.4.4 on the x86_64 vps, the same linux distributive, the same test Db, 1 schema about 10 tables, the same slon config [r...@vps9999 /]# ps auxf |grep slon root 9912 0.0 0.0 6040 584 pts/0 S+ 11:41 0:00 \_ grep slon postgres 7893 0.0 0.0 40640 1840 ? S 11:39 0:00 /usr/bin/slon postgres 7897 0.0 0.0 4108420 1500 ? Sl 11:39 0:00 \_ /usr/bin/slon [r...@vps9999 /]# The same huge VMZ segment 4G... i have ho idea where the bug... 10.06.2010 10:32, Alexander V Openkin пишет: > 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() > ~ > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
