Re: [ADMIN] Problems with heavy-loaded postgres

1998-10-13 Thread Marc G. Fournier
On Sat, 12 Sep 1998, Roelof Osinga wrote: > Stephane Dupille wrote: > > > > Hi there ! > > > > I got a problem with postgres on a heavy-loaded machine. > > > > I use postgres for a web-server. I access the database with a perl-5 > > CGI. > > A possible solution would b

Re: [ADMIN] Problems with heavy-loaded postgres

1998-10-12 Thread Roelof Osinga
Stephane Dupille wrote: > > Hi there ! > > I got a problem with postgres on a heavy-loaded machine. > > I use postgres for a web-server. I access the database with a perl-5 > CGI. A possible solution would be to switch to PHP3. You didn't say what webserver you're using

Re: [ADMIN] Problems with heavy-loaded postgres

1998-09-11 Thread Aldrin L.
On Fri, 11 Sep 1998, Chris Johnson wrote: > Come on now - this isn't a real solution! If the site is popular then he > will get more than 50 connections... fastcgi or not he will be over that > limit. Hm... i think on about three things: - Opening a connection does have some ov

Re: [ADMIN] Problems with heavy-loaded postgres

1998-09-11 Thread Chris Johnson
Come on now - this isn't a real solution! If the site is popular then he will get more than 50 connections... fastcgi or not he will be over that limit. Chris -- As I learn the innermost secrets of the people around me, they reward me in many ways to keep me quiet. On Fri, 11 Sep 1998, Aldrin

Re: [ADMIN] Problems with heavy-loaded postgres

1998-09-11 Thread Aldrin Leal
> When I try to access the database with 50 simultaneous connections, >the database crash, when I use the -o-F option for postmaster, and >doesn't crash if I do not use it. I suggest you to reduce the load postgresql receives. A trick is to use FastCGI, turning cgi sessions into full-time d

[ADMIN] Problems with heavy-loaded postgres

1998-09-11 Thread Stephane Dupille
Hi there ! I got a problem with postgres on a heavy-loaded machine. I use postgres for a web-server. I access the database with a perl-5 CGI. When I try to access the database with 50 simultaneous connections, the database crash, when I use the -o-F option for po