Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection
Date
Msg-id CAKFQuwahmdLkMy200LfLdENWVGOa64QEVCMgHyFF1=8m5gygRQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection  (Steven Grimm <sgrimm@thesegovia.com>)
Responses Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection
List pgsql-general
Tree view
On Saturday, June 10, 2017, Steven Grimm <sgrimm@thesegovia.com> wrote:
The problem doesn't appear to be specific to the JDBC driver. Tried a quick version of this in Python for grins with a database that was already populated by the Java code (sadly, the psycopg2 library doesn't directly support prepared statements):


Specifically, the notes section.

David J.

pgsql-general by date:

Previous
From: Steven Grimm
Date:
Subject: Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection
Next
From: Steven Grimm
Date:
Subject: Re: [GENERAL] Inconsistent performance with LIKE and bind variable onlong-lived connection