Re: Performance problems with Postgres JDBC 42.4.2

2023-11-08 Thread Dave Cramer
On Mon, 6 Nov 2023 at 09:59, Jose Osinde wrote: > > Dear all, > > I'm running a query from Java on a postgres database: > > Java version: 17 > JDBC version: 42.4.2 > Postgres version: 13.1 > > In parallel I'm testing the same queries from pgAdmin 4 version 6.13 > > The tables I'm using contains

Re: Function call very slow from JDBC/java but super fast from DBear

2023-08-09 Thread Dave Cramer
On Tue, 8 Aug 2023 at 17:07, An, Hongguo (CORP) wrote: > Hi: > > I have a function, if I call it from DBeaver, it returns within a minute. > > > > *call* commonhp.run_unified_profile_load_script_work_assignment_details( > 'BACDHP', 'G3XPM6YE2JHMSQA2'); > > > > > > but if I called it from spring

Re: Query out of memory

2021-10-19 Thread Dave Cramer
ely too high. With 250 connections there is no way you could allocate 2G to each one of them if needed Dave Cramer www.postgres.rocks

why does this query not use a parallel query

2018-03-02 Thread Dave Cramer
a parallel query explain analyze SELECT count(minion_id) FROM mob_player_mob_118 WHERE player_id = 55351078; Thanks Dave Cramer