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:30:32 |
Message-ID: | PH0PR11MB519109C0DD5E9CCAE097952BD6409@PH0PR11MB5191.namprd11.prod.outlook.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc pgsql-performance |
Please check attached.
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 |
From | Date | Subject | |
---|---|---|---|
Next Message | James Pang (chaolpan) | 2022-09-08 08:30:47 | Recall: Postgresql JDBC process consumes more memory with partition tables update delete |
Previous Message | James Pang (chaolpan) | 2022-09-08 08:30:13 | Recall: Postgresql JDBC process consumes more memory with partition tables update delete |
From | Date | Subject | |
---|---|---|---|
Next Message | James Pang (chaolpan) | 2022-09-08 08:32:14 | RE: Postgresql JDBC process consumes more memory with partition tables update delete |
Previous Message | James Pang (chaolpan) | 2022-09-08 08:24:03 | RE: Postgresql JDBC process consumes more memory with partition tables update delete |