Re: [GENERAL] PostgreSQL too heavy startup

Hello Igor,

I would suggest you look into using persistent connections, rather than
setting up a new connection for each request. This has greatly reduced the
load for me. Unfortunately, I don't think this can be done with cgi (but
possibly with fast-cgi?). I use PHP3 as an apache module with persistent
connections to postgresql which I can heavily recommend, or else I think it
is possible with mod_perl/DBD. I realize this doesn't really answer your
question, but may provide an alternative solution.

> Hi,
>
> I'm using P-100, 32M, 128M swap, FreeBSD 2.2.5-STABLE, Apache-1.2.6,
> perl 5.004_4, PostgreSQL-v6.3.2.
> One of CGI scripts makes select from database. When I try to quickly
> reload this script about 20 times in browser the FreeBSD starts to heavy
> swapping. I'd appled patch to remove exec() from startup code. It seems
> that nothing changed.
> Is there way to make more lighter startup ?
>
> with best regards,
> Igor Sysoev

--
Ivan Cornell, FrameStore Ltd
ivan(dot)cornell(at)framestore(dot)co(dot)uk