| From: | "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> |
|---|---|
| To: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Postgresql JDBC process consumes more memory than psql client |
| Date: | 2022-09-05 12:40:46 |
| Message-ID: | PH0PR11MB5191A047B707B2FE6527C549D67F9@PH0PR11MB5191.namprd11.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-performance |
We run same update or delete SQL statement " DELETE FROM ... WHERE ... " the table is a hash partition table (256 hash partitions). When run the sql from Postgresql JDBC driver, it soon increased to 150MB memory (RES filed from top command), but when run the same SQL from psql , it only consumes about 10MB memory. UPDATE statements is similar , need 100MB memory, even it delete or update 0 rows. Any specific control about Postgresql JDBC driver ?
Thanks,
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2022-09-05 12:47:22 | Re: Postgresql JDBC process consumes more memory than psql client |
| Previous Message | Dave Cramer | 2022-09-02 19:42:23 | [pgjdbc/pgjdbc] 996a05: correct base url |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2022-09-05 12:47:22 | Re: Postgresql JDBC process consumes more memory than psql client |
| Previous Message | Jose Osinde | 2022-08-25 13:52:30 | Re: Select on partitioned table is very slow |