Problems with listen / notify

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: psycopg(at)postgresql(dot)org
Subject: Problems with listen / notify
Date: 2014-06-18 14:14:46
Message-ID: 53A19ED6.20806@usit.uio.no
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: psycopg

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello

I am experiencing some strange behaviour with listen/notify via psycopg2.

When executing multiple notifies in a server *without* problems, a
python script gets all notifies defined in a period of time in one
poll() call (as expected)

But when running the same code against a server *with* problems, the
python script gets only one notify per poll() call.

Check http://pastebin.com/9itGKxJR for details of the two runs and the
python code used for this test.

postgreSQL version: 9.2.8
python 2.6.6 (RHEL6)
psycopg version: 2.5.3-1.rhel6

Any ideas about why this is happening?
Thanks in advance.

regards
- --
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)

iEYEARECAAYFAlOhntYACgkQBhuKQurGihSZMACeMhwVvHMuk2Qm3BgXpW/r5cFb
fsEAn3IfIkr/rECFZ3mJ4NbagoGBx7fL
=VucW
-----END PGP SIGNATURE-----

Responses

Browse psycopg by date

  From Date Subject
Next Message Karsten Hilbert 2014-06-18 14:33:56 Re: Problems with listen / notify
Previous Message Adrian Klaver 2014-06-11 15:28:40 Re: PgBouncer doubts