[Pgpool-general] pgpool-II-3.0.3and4 memory leaks
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Jul 6 07:13:35 UTC 2011
I am not familiar with Python and am not sure what kind of queries are
actually sent. How long did it take before observing the memory leak?
minutes? hours? days?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> 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()
> --------------------
More information about the Pgpool-general
mailing list