laurent.dechambe@xxxxxxxxxx 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
