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

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

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