Re: [ADMIN] Weird processes

2002-11-24 Thread Tomaz Borstnar
At 10:47 14.11.2002 -0500, A.M. wrote the following message: What you're looking for is SQLRelay. one can not use sql relay as fake postgresql server? Thanks in advance. Tomaz ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Weird processes

2002-11-14 Thread dima
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 t

Re: [ADMIN] Weird processes

2002-11-14 Thread A.M.
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

Re: [ADMIN] Weird processes

2002-11-14 Thread dima
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 whic

Re: [ADMIN] Weird processes

2002-11-14 Thread Chris Miles
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

Re: [ADMIN] Weird processes

2002-11-13 Thread dima
every concurrent cgi script uses its own postgres connection in your case. you're going to run into more serious problems (e.g. empty pages for no reason) because of lack of possible postgres connections. so, 1) try mod_perl to speed up your perl scripts 2) think about writing a server which woul

Re: [ADMIN] Weird processes

2002-11-13 Thread Tom Lane
Gary DeSorbo <[EMAIL PROTECTED]> writes: > I have been having some problems with my database/web server machine > and ma having difficulty in finding out what the problem is. I have > two machines configured exactly the same; one for development and one > for production. Pages on production are

Re: [ADMIN] Weird processes

2002-11-13 Thread Marc Mitchell
terprise Information Solutions, Inc. Downers Grove, IL 60515 [EMAIL PROTECTED] - Original Message - From: "Gary DeSorbo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 13, 2002 1:38 PM Subject: [ADMIN] Weird processes > I have been having some

[ADMIN] Weird processes

2002-11-13 Thread Gary DeSorbo
I have been having some problems with my database/web server machine and ma having difficulty in finding out what the problem is. I have two machines configured exactly the same; one for development and one for production. Pages on production are taking up to 10X longer to load than the same pa