Postgres Pro
Downloads
Home   >   mailing lists

Re: Psycopg and prepared SQL statements - Mailing list psycopg

From Christophe Pettus
Subject Re: Psycopg and prepared SQL statements
Date
Msg-id 672F9AEB-E3A6-4548-AB7C-74F3CC5E8672@thebuild.com
Whole thread Raw
In response to Psycopg and prepared SQL statements  (Nicolas Boullis <postgresql@ilcode.fr>)
Responses Re: Psycopg and prepared SQL statements
List psycopg
Tree view 
On May 16, 2014, at 2:22 PM, Nicolas Boullis <postgresql@ilcode.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@thebuild.com

psycopg by date:

Previous
From: Nicolas Boullis
Date:
Subject: Psycopg and prepared SQL statements
Next
From: Nicolas Boullis
Date:
Subject: Re: Psycopg and prepared SQL statements