This answer is exactly on target, I surmise.
But what I need is an ISP who utilizes pgbouncer (or who would, much
more unlikely, permit me to install it).
In other words, I can design the database and the perl script, but I
am at the mercy of whatever ISP I try to use.
Do all ISP's use pgbouncer, or can I be referred to one who does?
Thanks
John
On May 28, 2010, at 9:56 AM, A. Kretschmer wrote:
> In response to John Gage :
>> In other words, there are 4,500 unique users accessing the website,
>> each uniquely identified via http authentication, but only ONE
>> postgres user who they all share to access the database, which
>> implies
>> that a single, unique postgres user will be opening and closing
>> connections to the database perhaps a thousand times a minute.
>>
>> Does this work?
>>
>> If it doesn't, are there any suggestions?
>
> I think you should consider a connection pooler like pgbouncer.
>