Greetings,
I am having a problem with Postgres' speed when I receive HUGE amounts of traffic / queries (approx. 200 simultaneous users performing on average 300-400 queries per second).
I was using pg_connect then after switching to pg_pconnect I noticed the site FLEW!!!
The only problem is the number of httpd processes also flies, and in a few minutes it exceeds the max number of connections allowed when running postgres and thus crashes the server.
I've set shared mem, buffers to very high amounts, I'm running on a FreeBSD machine with PostgreSQL 7.1.3, 1Gig RAM and dual PIII-1GHz processors. I've built my kernal to donate 75% of the RAM to SHMHAX (or to postgres)
in my situation, should I be using pg_connect or pg_pconnect?? pg_connect takes a lot longer to reach max connections, but ti still does and is generally slower than pg_pconnect. however if I use either of these methods I still need ot find a way to kill off processes so they don't surpass the max connections.
any help on this problem ASAP would be greatly appreciated.
Thankx, Keith
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
(514) 398-9994 ext.225
Senior Programmer
<!-- m --><a class="postlink" href="http://www.wisol.com">http://www.wisol.com</a><!-- m -->
I am having a problem with Postgres' speed when I receive HUGE amounts of traffic / queries (approx. 200 simultaneous users performing on average 300-400 queries per second).
I was using pg_connect then after switching to pg_pconnect I noticed the site FLEW!!!
The only problem is the number of httpd processes also flies, and in a few minutes it exceeds the max number of connections allowed when running postgres and thus crashes the server.
I've set shared mem, buffers to very high amounts, I'm running on a FreeBSD machine with PostgreSQL 7.1.3, 1Gig RAM and dual PIII-1GHz processors. I've built my kernal to donate 75% of the RAM to SHMHAX (or to postgres)
in my situation, should I be using pg_connect or pg_pconnect?? pg_connect takes a lot longer to reach max connections, but ti still does and is generally slower than pg_pconnect. however if I use either of these methods I still need ot find a way to kill off processes so they don't surpass the max connections.
any help on this problem ASAP would be greatly appreciated.
Thankx, Keith
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
(514) 398-9994 ext.225
Senior Programmer
<!-- m --><a class="postlink" href="http://www.wisol.com">http://www.wisol.com</a><!-- m -->