Yes, same prepared statement from both psql and JDBC. We started to
compare with one by one, and see big difference as explained. Psql and JDBC
show big difference. Let's focuse on JDBC driver client ,why it consumes 160MB
memory even table size is very small. But only consumes 25MB for
Yes, same prepared statement from both psql and JDBC. We started to compare
with one by one, and see big difference as explained. Psql and JDBC show big
difference. Let's focuse on JDBC driver client ,why it consumes 160MB memory
even table size is very small.
-Original Message-
F
Hello Guys.
I'd like to report back on this issue as I've been monitoring on this
installation that has very large distinct sqls and I noticed something that
isn't probably new here but I'd like to confirm that again.
So after I reduced the pg_stat_statements.max from 10k to 3k
pgss_query_texts.s
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
