Re: Probable memory leak with ECPG and AIX

From: talk to ben <blo(dot)talkto(at)gmail(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>, "Dr(dot) Michael Meskes" <michael(dot)meskes(at)credativ(dot)com>
Subject: Re: Probable memory leak with ECPG and AIX
Date: 2021-12-13 13:07:36
Message-ID: CAPE8EZ4ca2s5tDVHZzQ=iGh+rD8VX5r4Gk8zTTEeh9VaDOMnuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

(I work with Guillaume on this case.)

On Sun, Dec 12, 2021 at 8:34 AM Noah Misch <noah(at)leadboat(dot)com> wrote:

> That almost certainly means he's using a 32-bit binary with the default
> heap
> size. To use more heap on AIX, build 64-bit or override the heap size.
> For
> example, "env LDR_CNTRL=MAXDATA=0x80000000 ./a.out" gives 2GiB of heap.
> See
>
> https://www.postgresql.org/docs/devel/installation-platform-notes.html#INSTALLATION-NOTES-AIX
> for more ways to control heap size. While that documentation focuses on
> the
> server, the same techniques apply to clients like your test program.
>
> That said, I don't know why your test program reaches 256MB on AIX. On
> GNU/Linux, it uses a lot less. What version of PostgreSQL provided your
> client libraries?
>

They use a 12.3 in production but have also tested on a 12.9 with the same
result.
We relayed your suggestion and will get back to you with the results.

Thanks for the input !

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2021-12-13 13:20:40 Re: using extended statistics to improve join estimates
Previous Message osumi.takamichi@fujitsu.com 2021-12-13 12:18:15 RE: Failed transaction statistics to measure the logical replication progress