Re: psycopg2 hang with multithread frequent queries

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: David Roid <dataroid(at)gmail(dot)com>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: psycopg2 hang with multithread frequent queries
Date: 2012-09-14 16:53:12
Message-ID: CA+mi_8aiQWdogfvj2UtBz5bDh9W+59SFC7rqmrAy_ug-osPPTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On Fri, Sep 14, 2012 at 5:45 PM, David Roid <dataroid(at)gmail(dot)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

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message David Roid 2012-09-14 16:55:51 Re: psycopg2 hang with multithread frequent queries
Previous Message David Roid 2012-09-14 16:45:04 psycopg2 hang with multithread frequent queries