From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
---|---|
To: | "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> |
Cc: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>, "pgsql-jdbc(at)lists(dot)postgresql(dot)org" <pgsql-jdbc(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgresql JDBC process consumes more memory with partition tables update delete |
Date: | 2022-09-08 09:31:15 |
Message-ID: | CADK3HH+gQ99XFoADC5vq4EL02J2Hh+YU3sAimb0Hh6r8EY-4LA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc pgsql-performance |
On Thu, 8 Sept 2022 at 04:36, James Pang (chaolpan) <chaolpan(at)cisco(dot)com>
wrote:
>
>
> Please check attached. Removed some dbname and tablename , the
> interesting thing is we only see this issue by JDBC driver client, for psql
> client , only 25MB memory and similar SQL plan used.
>
>
>
> Thanks,
>
> James
>
> *From:* Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
> *Sent:* Thursday, September 8, 2022 3:05 PM
> *To:* James Pang (chaolpan) <chaolpan(at)cisco(dot)com>
> *Cc:* pgsql-jdbc(at)lists(dot)postgresql(dot)org
> *Subject:* Re: Postgresql JDBC process consumes more memory with
> partition tables update delete
>
>
>
> > > Yesterday, when workload test, a lot of Postgresql JDBC connections
> > > use 150-160MB memory , so we got ERROR: out of memory
>
> Would you please share a reproducer? (e.g. DDL for the table, test code)
>
>
>
> Have you tried capturing memory context information for the backend that
> consumes memory?
>
> https://wiki.postgresql.org/wiki/Developer_FAQ#Examining_backend_memory_use
>
> Vladimir
>
I'd like to see the actual statement for each. Can you turn on log all
statements in the back end and capture the actual statement for psql and
jdbc ?
Dave Cramer
www.postgres.rocks
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Sitnikov | 2022-09-08 09:55:38 | Re: Postgresql JDBC process consumes more memory with partition tables update delete |
Previous Message | James Pang (chaolpan) | 2022-09-08 08:36:30 | RE: Postgresql JDBC process consumes more memory with partition tables update delete |
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Sitnikov | 2022-09-08 09:55:38 | Re: Postgresql JDBC process consumes more memory with partition tables update delete |
Previous Message | James Pang (chaolpan) | 2022-09-08 08:36:30 | RE: Postgresql JDBC process consumes more memory with partition tables update delete |