ssage-
From: Justin Pryzby
Sent: Wednesday, September 7, 2022 12:15 AM
To: James Pang (chaolpan)
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql JDBC process consumes more memory than psql client
On Tue, Sep 06, 2022 at 04:15:03AM +, James Pang (chaolpan) wrote:
> W
On Tue, Sep 06, 2022 at 04:15:03AM +, James Pang (chaolpan) wrote:
> We make 2 comparisions between partitioned(256 HASH) and no-partitioned(same
> data volume,same table attributes) , do same "UPDATE,DELETE " .
> 1. with partitioned tables , the "RES" from top command memory increased
> qu
mory is about 128GB.
Thanks,
James
-Original Message-
From: James Pang (chaolpan)
Sent: Monday, September 5, 2022 8:52 PM
To: Justin Pryzby
Cc: pgsql-performance@lists.postgresql.org
Subject: RE: Postgresql JDBC process consumes more memory than psql client
PG V13, yes JDBC use prepared
On Mon, Sep 05, 2022 at 12:52:14PM +, James Pang (chaolpan) wrote:
> Any idea how to print SQL plan from JDBC driver ?
You could use "explain execute" on the client, or autoexplain on the
server-side.
--
Justin
: pgsql-performance@lists.postgresql.org
Subject: Re: Postgresql JDBC process consumes more memory than psql client
On Mon, Sep 05, 2022 at 12:40:46PM +, James Pang (chaolpan) wrote:
> We run same update or delete SQL statement " DELETE FROM ... WHERE ... "
> the table is
On Mon, Sep 05, 2022 at 12:40:46PM +, James Pang (chaolpan) wrote:
> 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
