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
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 j
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
Adam,
I think the first thing to do is to make hackers aware of the specifics of
which indexes are being used etc so that the planner could be taught how to
use better ones.
Self contained examples do wonders
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 11 April 2018 at 01:59
parallel query
explain analyze SELECT count(minion_id) FROM mob_player_mob_118 WHERE
player_id = 55351078;
Thanks
Dave Cramer
