From: | dima <_pppp(at)mail(dot)ru> |
---|---|
To: | "A(dot)M(dot)" <agentm(at)cmu(dot)edu> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Weird processes |
Date: | 2002-11-14 15:59:46 |
Message-ID: | 3DD3C872.6010001@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Unfortunately Apache::DBI handles per-process connections only. So,
almost any httpd child will hold all the connections. If you use user
sessions as well, you'll run even into more serious troubles.
> What you're looking for is SQLRelay. You will need to work a little bit
> around the DBI driver to get the cached connections, but since the
> driver uses its native interface, this is possible (or you can scrap DBI
> altogether- not recommended). Get it here:
> http://taonix.org/
> because firstworks.com has been down for months.
> It's works great. The other probably better option (though not always
> possible to use) would be mod_perl and Apache::DBI connection pooling.
> This would be the easiest solution because it would require
> minimal-to-none code changes.
> While it would be possible to collect db handles in shared memory,
> it would still require a persistently running daemon- SQLRelay does
> essentially that, only it has more features. Apache::DBI caches the
> handles in Apache space and hands you the handle that has exactly the
> same connection parameters and is more configurable as a connection pooler.
> Good luck.
>
> On Thursday, November 14, 2002, at 03:03 AM, Chris Miles wrote:
>
>> On Thu, Nov 14, 2002 at 10:47:20AM +0300, dima wrote:
>>
>>> 2) think about writing a server which would provide cgi scripts with
>>> cached connections; you can $handle->prepare(...) the most common
>>> queries as well.
>>
>>
>> This seems like a common requirement. Are there any such tools which
>> can be run in a web server (or similar) environment to keep a pool
>> of postgresql connections, and perhaps cache common queries also?
>>
>> Regards,
>> Chris
>>
>> --
>> Chris Miles
>> chris_pg002(at)psychofx(dot)com
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>>
> ><><><><><><><><><
> AgentM
> agentm(at)cmu(dot)edu
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hugh Esco | 2002-11-14 17:54:49 | Re: Troubles at Startup |
Previous Message | A.M. | 2002-11-14 15:47:01 | Re: Weird processes |