Re: PHP + Postgres: More than 1000 postmasters produce - Mailing list pgsql-general

From scott.marlowe
Subject Re: PHP + Postgres: More than 1000 postmasters produce
Date
Msg-id Pine.LNX.4.33.0402201019450.10445-100000@css120.ihs.com
Whole thread Raw
In response to PHP + Postgres: More than 1000 postmasters produce 70.000 context switches  ("Gellert, Andre" <AGellert@ElectronicPartner.de>)
List pgsql-general
Have you tested it with regular pg_connects instead of pg_pconnect?  while
many people expect pconnects to be faster, often, when they result in the
database having lots of open idle connections, they actually make the
system slower than just using plain connects.

You might want to look into some of the connection pooling options out
there that work with PHP, as persistant connections work well only for a
smaller number of hard working threads, and not so well for a large number
of connections of which only a few are actually hitting the db at the
same time.  The becomes especially bad in your situation, where it sounds
like you have multiple databases to connect to, so php is keeping multiple
backends alive for each front end thread.


pgsql-general by date:

Previous
From: tibor
Date:
Subject: Re: How can I delete a primary or foreign key?
Next
From: "scott.marlowe"
Date:
Subject: Re: PHP + Postgres: More than 1000 postmasters produce