Re: Psycopg and prepared SQL statements

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Nicolas Boullis <postgresql(at)ilcode(dot)fr>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Psycopg and prepared SQL statements
Date: 2014-05-16 12:25:14
Message-ID: 672F9AEB-E3A6-4548-AB7C-74F3CC5E8672@thebuild.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: psycopg


On May 16, 2014, at 2:22 PM, Nicolas Boullis <postgresql(at)ilcode(dot)fr> wrote:

> As performance matters, I am using a ThreadedConnectionPool from
> psycopg2.pool, but I also want to have my SQL statements prepared.

Why?

This an honest question. In general, prepared statements do not provide significant performance improvements in PostgreSQL.

--
-- Christophe Pettus
xof(at)thebuild(dot)com

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Nicolas Boullis 2014-05-16 12:34:21 Re: Psycopg and prepared SQL statements
Previous Message Nicolas Boullis 2014-05-16 12:22:22 Psycopg and prepared SQL statements