From: | John Gage <jsmgage(at)numericable(dot)fr> |
---|---|
To: | NOVICE Postgres elist <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Reality check |
Date: | 2010-05-28 08:08:47 |
Message-ID: | D9790693-3B67-4A48-AADE-8448E480C0B9@numericable.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2010-05-28 08:09:26 | Re: Reality check |
Previous Message | A. Kretschmer | 2010-05-28 07:56:47 | Re: Reality check |