using the same connection?

From: Mathieu Dube <mathieu_dube(at)videotron(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: using the same connection?
Date: 2001-02-06 16:08:49
Message-ID: 01020611115202.14015@therver.local2.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi y'all,
Is it a bad idea for an app to keep just a couple of connections to a
database, put semaphore/mutex on them and reuse them all through the program?
Of course I would check if their PQstatus isnt at CONNECTION_BAD and
reconnect if they were...
I need some opinions on that practice...

Thanks
-Mat

--
Mathieu Dube
Mondo-Live
www.flipr.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mitch Vincent 2001-02-06 16:15:59 Re: full text searching
Previous Message Tom Lane 2001-02-06 15:54:51 Re: little bug in current CVS