Re: BUG #6763: Severe memory leak with arrays and hstore - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: BUG #6763: Severe memory leak with arrays and hstore
Date
Msg-id 5011FD5D.3040503@ringerc.id.au
Whole thread Raw
In response to Re: BUG #6763: Severe memory leak with arrays and hstore  (luben karavelov <karavelov@mail.bg>)
Responses Re: BUG #6763: Severe memory leak with arrays and hstore
List pgsql-bugs
Hi all

Here's a fully self contained, automated test case that demonstrates the
leak.

Example output on my system, pasted as quote to stop Thunderbird
mangling it:

> $ ./hstore-leak-demo.sh
> NOTICE:  extension "hstore" already exists, skipping
> CREATE EXTENSION
> DROP TABLE
> CREATE TABLE
> CREATE TABLE
> INSERT 0 100000
> INSERT 0 80175
> INSERT 0 72267
> INSERT 0 50649
> INSERT 0 30430
>         avg         | max
> --------------------+-----
>  3.3352100000000000 |  20
> (1 row)
>
> Backend PID is: 3167
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167  0.0  0.0 504276  4368 ?        Ss   10:29   0:00 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 91.0 13.0 2163384 1055652 ?     Ss   10:29   0:00 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 77.5 13.2 2163408 1071496 ?     Ss   10:29   0:01 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167  108 13.4 2163408 1084056 ?     Ss   10:29   0:02 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 93.0 13.5 2163408 1092244 ?     Ss   10:29   0:02 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 86.0 13.6 2163408 1100444 ?     Ss   10:29   0:03 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167  101 13.7 2163408 1108704 ?     Ss   10:29   0:04 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 93.8 13.8 2163408 1116896 ?     Ss   10:29   0:04 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 88.8 13.9 2163408 1125048 ?     Ss   10:29   0:05 postgres: craig regress [local] idle
> USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
> postgres  3167 99.1 14.0 2163408 1133228 ?     Ss   10:29   0:05 postgres: craig regress [local] idle


Attachment

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #6763: Severe memory leak with arrays and hstore
Next
From: Craig Ringer
Date:
Subject: Re: BUG #6763: Severe memory leak with arrays and hstore