laurent(dot)dechambe(at)orange(dot)com 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