[Pgpool-general] pgpool-II-3.0.3and4 memory leaks

[takehiro wada]

Hi,

I'm using pgpool-II-3.0.3 and I have a memory problem of pgpool-II-3.0.3.
-------
$ ps uaxww | grep i18n_generic_search
 postgres 11188  0.0 40.0 3722712 2452996 ?     S    Jun20   7:54 pgpool:
postgres postgres 127.0.0.1(49676) idle
* physical memory is used 2GB the above process.
-------

I have been looking into the problem by creating a testcase.
>From the testcase, what I found is that the mount of used memory keeps
growing while an application executes SQLs in the period that the
application is connecting to pgpool.
Have you had any similar case so far?

testcase
--------------------
import psycopg2
import time
import sys

try:
    connection = psycopg2.connect( database='postgres',
                                   user='postgres'    ,
                                   host='127.0.0.1'   , << pgpool server's
host
                                   port='10000'       , << pgpool server's
port
                                   password='postgres')
except:
    print ("Could Not connect to PostgreSQL or pgpool Server")

### main ###
cursor = connection.cursor()

while 1:
  cursor.execute("select datname from pg_database")
  rows = cursor.fetchall()
  time.sleep(0.1)

cursor.close()
connection.close()

exit()
--------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110704/6f66c113/attachment.html>