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
