Valgrind may help. Can you try the following steps? 1. Set num_init_children to 1 in pgpool.conf 2. Launche pgpool with valgrind $ valgrind --leak-check=full pgpool -n -d -f pgpool.conf >> valgrind.log 2>&1 3. Run your script 4. Stop pgpool
Thanks, 2011/7/8 takehiro wada <[email protected]>: > Hi > This porblem occurs in 2.6.9-67, 2.6.26-2 and 2.6.38-8 of Linux Kernels of > Redhat, Debian and Ubuntu without depending on operating mode of pgpool as > far as I confirmed. > On our production environment, this problem occurs, operating mode of pgpool > is streaming replication. > > My pgpool.conf of testcase is below. > > pgpool.conf > -------------------------------------------- > pid_file_name = '/var/run/pgpool/pgpool.pid' > port = 10000 > backend_hostname0 = 'localhost' > backend_port0 = 5432 > -------------------------------------------- > > thanks > > 2011/7/7 Tatsuo Ishii <[email protected]> >> >> I have tried with your shell script with pgpool-II CVS HEAD. Between >> 16:56 and 17:26, about 30k SELECTs have been executed so far. As you >> can see RSS was growing from 1904 to 1912 but VSZ remained unchanged >> 23208. Thus I think there's no memory leaking. Pgpool-II is operated >> in streaming replication mode. This is Linux kernel 2.6.27. What mode >> are you operating? What platform are you using? >> >> Thu Jul 7 16:56:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1904 ? S ? 0:03 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> Thu Jul 7 17:01:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1904 ? S ? 0:04 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> Thu Jul 7 17:06:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1908 ? S ? 0:05 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> Thu Jul 7 17:11:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1908 ? S ? 0:06 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> Thu Jul 7 17:16:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1908 ? S ? 0:07 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> Thu Jul 7 17:21:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1908 ? S ? 0:08 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> Thu Jul 7 17:26:43 JST 2011 >> F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME >> COMMAND >> 1 48 29388 29356 20 0 23208 1912 ? S ? 0:09 >> pgpool: t-ishii postgres 127.0.0.1(46350) idle >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> English: http://www.sraoss.co.jp/index_en.php >> Japanese: http://www.sraoss.co.jp > > > > -- > ************************* > Name:Takehiro Wada > mail:[email protected] > ************************* > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > > -- Yoshiyuki Asaba [email protected] _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
