15x slower PreparedStatement vs raw query

From: Alex <cdalxndr(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: 15x slower PreparedStatement vs raw query
Date: 2021-05-02 19:45:26
Message-ID: 3f8c88d8a6ef9.d82fa04cf610d@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

PreparedStatement: 15s
Raw query with embedded params: 1s
See issue on github with query and explain analyze:
https://github.com/pgjdbc/pgjdbc/issues/2145
<https://github.com/pgjdbc/pgjdbc/issues/2145>

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2021-05-03 20:18:12 Re: 15x slower PreparedStatement vs raw query
Previous Message Vijaykumar Jain 2021-04-30 17:43:18 Re: Error while calling proc with table type from Application (npgsql)