Re: Pg10 : Client Configuration for Parallelism ?

Thomas Kellerer <[email protected]> Fri, 19 Apr 2019 08:52:24 +0200

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[email protected]>

[email protected] schrieb am 17.04.2019 um 16:33:
> Hello Justin and thank you for your clues.
>
> Finally I found that putting blank to the option that limits the
> number of rows to retrieve (which is normal for this kind of tool)
> allows PostgreSQL to parallelize the query.
>
> On jdbc it seems this is equivalent to write :
> statement. setMaxRows(0);  // parallelism authorized, which is the default.
>
> Thus on my jdbc basic program if I add :
> statement. setMaxRows(100);  // No parallelism allowed (at least in Pg10)
>
> Thanks to all who were kind enough to help.

This isn't limited to Statement.setMaxRows()

If you use "LIMIT x" in your SQL query, the same thing happens.

Thomas