Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Inconsistent performance with LIKE and bind variable on long-lived connection
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sat, 10 Jun 2017 23:10:19 -0700
Cc: rob stone <floriparob@xxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAOFXwWXx0FHeYdKAK3GsMePmvPng4oQtQa-dJArM1+EQqHnCSQ@mail.gmail.com>
References: <CAOFXwWWhOYzhxAkQZzfZYPg2r-p_QvAaO31x7RpeBzJiEtEKpg@mail.gmail.com> <65641F01-5BC1-4EDF-AA1F-69796D6EFC83@gmail.com> <CAOFXwWX1F_w_aRfiLk2HmP2j9dQiZN1SYT8BxgaiHALv-a2e+A@mail.gmail.com> <1497130258.11174.1.camel@gmail.com> <CAOFXwWXx0FHeYdKAK3GsMePmvPng4oQtQa-dJArM1+EQqHnCSQ@mail.gmail.com>

On Saturday, June 10, 2017, Steven Grimm <sgrimm@xxxxxxxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Inconsistent performance with LIKE and bind variable on long-lived connection
  - From: Steven Grimm

References:
- Inconsistent performance with LIKE and bind variable on long-lived connection
  - From: Steven Grimm
- Re: Inconsistent performance with LIKE and bind variable on long-lived connection
  - From: Alban Hertroys
- Re: Inconsistent performance with LIKE and bind variable on long-lived connection
  - From: Steven Grimm
- Re: Inconsistent performance with LIKE and bind variable on long-lived connection
  - From: rob stone
- Re: Inconsistent performance with LIKE and bind variable on long-lived connection
  - From: Steven Grimm

Prev by Date: Re: Inconsistent performance with LIKE and bind variable on long-lived connection
Next by Date: Re: Inconsistent performance with LIKE and bind variable on long-lived connection
Previous by thread: Re: Inconsistent performance with LIKE and bind variable on long-lived connection
Next by thread: Re: Inconsistent performance with LIKE and bind variable on long-lived connection
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]