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

Поиск
Список
Период
Сортировка
От James Pang (chaolpan)
Тема RE: Postgresql JDBC process consumes more memory with partition tables update delete
Дата
Msg-id PH0PR11MB519188F46BD5595EF6F225A3D6409@PH0PR11MB5191.namprd11.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Postgresql JDBC process consumes more memory with partition tables update delete  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения

 

Please check attached.

 

Thanks,

James

From: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Sent: Thursday, September 8, 2022 3:05 PM
To: James Pang (chaolpan) <chaolpan@cisco.com>
Cc: pgsql-jdbc@lists.postgresql.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?

Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: Recall: Postgresql JDBC process consumes more memory with partition tables update delete
Следующее
От: "James Pang (chaolpan)"
Дата:
Сообщение: Recall: Postgresql JDBC process consumes more memory with partition tables update delete