Postgres Pro
Downloads
Home   >   mailing lists

Re: psycopg2 hang with multithread frequent queries - Mailing list psycopg

From David Roid
Subject Re: psycopg2 hang with multithread frequent queries
Date
Msg-id CAKN1bq42mok-9htsZJK3BVVDgi5weGSpTnDrqJitVARTB1Pi+A@mail.gmail.com
Whole thread Raw
In response to Re: psycopg2 hang with multithread frequent queries  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List psycopg
Tree view
Hi Daniele, it's 2.4.5.        -David

2012/9/15 Daniele Varrazzo <daniele.varrazzo@gmail.com>
On Fri, Sep 14, 2012 at 5:45 PM, David Roid <dataroid@gmail.com> wrote:
> Greetings list,
>
> I'm using psycopg2, python2.7.3 threading along with pgsql 9.1.5. I noticed
> that if I have my python process query against the database kind of
> frequently, say more than 1 query per second, it's almost 100% sure to hit
> some problem, but first some backgroud:

No, first, what psycopg version? In the last versions we have fixed a
couple multithread-related bugs (one in 2.4.2, one in 2.4.5, see NEWS
file).

-- Daniele

psycopg by date:

Previous
From: David Roid
Date:
Subject: Re: psycopg2 hang with multithread frequent queries
Next
From: David Roid
Date:
Subject: Re: psycopg2 hang with multithread frequent queries