Re: 15x slower PreparedStatement vs raw query

2021-05-03 Thread Justin Pryzby
On Sun, May 02, 2021 at 07:45:26PM +, Alex wrote: > PreparedStatement: 15s > Raw query with embedded params: 1s > See issue on github with query and explain analyze: > https://github.com/pgjdbc/pgjdbc/issues/2145 | ..PostgreSQL Version? 12 |Prepared statement |... |Planning Time: 11.596 ms |E

15x slower PreparedStatement vs raw query

2021-05-03 Thread Alex
PreparedStatement: 15s Raw query with embedded params: 1s See issue on github with query and explain analyze: https://github.com/pgjdbc/pgjdbc/issues/2145