Re: Inconsistent performance with LIKE and bind variable on long-lived connection

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Steven Grimm <sgrimm(at)thesegovia(dot)com>
Cc: rob stone <floriparob(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inconsistent performance with LIKE and bind variable on long-lived connection
Date: 2017-06-11 06:10:19
Message-ID: CAKFQuwahmdLkMy200LfLdENWVGOa64QEVCMgHyFF1=8m5gygRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, June 10, 2017, Steven Grimm <sgrimm(at)thesegovia(dot)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):
>

https://www.postgresql.org/docs/current/static/sql-prepare.html

Specifically, the notes section.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Grimm 2017-06-11 08:10:44 Re: Inconsistent performance with LIKE and bind variable on long-lived connection
Previous Message Steven Grimm 2017-06-11 05:10:44 Re: Inconsistent performance with LIKE and bind variable on long-lived connection