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

From: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
To: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
Cc: "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 08:36:30
Message-ID: PH0PR11MB5191FC6F31970A43B81BC76CD6409@PH0PR11MB5191.namprd11.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-performance


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

Attachment Content-Type Size
postgresql-jdbc-partition-table-highmemroy.txt text/plain 22.8 KB

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2022-09-08 09:31:15 Re: Postgresql JDBC process consumes more memory with partition tables update delete
Previous Message James Pang (chaolpan) 2022-09-08 08:33:25 Recall: Postgresql JDBC process consumes more memory with partition tables update delete

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2022-09-08 09:31:15 Re: Postgresql JDBC process consumes more memory with partition tables update delete
Previous Message James Pang (chaolpan) 2022-09-08 08:32:14 RE: Postgresql JDBC process consumes more memory with partition tables update delete