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 more than 10million rows each and I have two
questions here:
1. I
Very good point from Danny: generic and custom plans.
One thing that is almost certainly not at play here, and is mentioned: there
are some specific cases where the planner does not optimise for the query in
total to be executed as fast/cheap as possible, but for the first few rows. One
reason