Re: Postgresql JDBC process consumes more memory with partition tables update delete

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

In response to

Browse pgsql-jdbc by date

  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

Browse pgsql-performance by date

  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