Postgres Pro
Downloads
Home   >   mailing lists

Sv: Pg10 : Client Configuration for Parallelism ? - Mailing list pgsql-performance

From Andreas Joseph Krogh
Subject Sv: Pg10 : Client Configuration for Parallelism ?
Date
Msg-id VisenaEmail.25.35fa198f3781c296.16a2a8aa2f0@tc7-visena
Whole thread Raw
In response to Pg10 : Client Configuration for Parallelism ?  (<laurent.dechambe@orange.com>)
Responses RE: Pg10 : Client Configuration for Parallelism ?
List pgsql-performance
Tree view
På onsdag 17. april 2019 kl. 08:30:28, skrev <laurent.dechambe@orange.com>:
Hi,

I am working on PostgreSQL 10.5 and I have a discrepancy between clients regarding parallelism feature.

For a simple query (say a simple SELECT COUNT(*) FROM BIG_TABLE), I can see PostgreSQL use parallelism when the query is launched from psql or PgAdmin4. However the same query launched with DBeaver (ie connected through JDBC) does not use parallelism.

SELECT current_setting('max_parallel_workers_per_gather')  gives 10 from my session.

Is there a client configuration that prevents from using parallelism ?

Thanks.

Laurent
 
Set in postgresql.conf:
 
log_statement = 'all'
 
reload settings and check the logs for what statemets are acutally issued.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Pg10 : Client Configuration for Parallelism ?
Next
From:
Date:
Subject: RE: Pg10 : Client Configuration for Parallelism ?