Apache + PHP + Postgres Interaction

From: "Max Zorloff" <zorloff(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Apache + PHP + Postgres Interaction
Date: 2007-08-23 18:06:28
Message-ID: op.txixw2k8ll0p5y@1-rtt202dnf3uds.mshome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

I have a subject setup and a few questions.

The first one is this. PHP establishes a connection to the Postgres
database through pg_pconnect(). Then it
runs some query, then the script returns, leaving the persistent
connection hanging. But the trouble
is that in this case any query takes significantly more time to execute
than in the case of one PHP script
running the same query with different parameters for N times. How can I
achieve the same performance in the first
case? Persistent connections help but not enough - the queries are still
10 times slower than they would be on
the 2nd time.

The second one is that the machine with this setup is dual core Xeon
2.8ghz. I've read somewhere about
the switching context problem and bad postgres performance. What are the
effects? What are the symptoms?
And what will be the performance gain if I change the machine to equal
Athlon?

Thank you in advance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lewis Cunningham 2007-08-23 18:25:21 Re: PostgreSQL vs Firebird feature comparison finished
Previous Message Scott Marlowe 2007-08-23 18:04:01 Re: PostgreSQL vs Firebird feature comparison finished