You can try using pg_pconnect instead of
pg_connect. It has some downsides so see the docs.
Also - check your memory usage, it may be you could
fix this by reducing work_mem or similar.
Regards,
Ben
"Najib Abi Fadel" [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...Hi
What is the problem with pg_pconnect and is pgpool easy to use with an already running application ?Should i expect a major performance boost ? Najib."Joshua D. Drake" [EMAIL PROTECTED] wrote: Nikolay Samokhvalov wrote: As for persistent connection with PHP, start from here:
As for persistent connection with PHP, start from here:
http://php.net/pg_pconnect.
Also, I recommend to ensure that you have proper set of indexes on
your tables and your system doesn't use badly written queries (such as
join of several dozens of tables :-) ). There is an excellent tool
that
Hi again,How can i use connection pooling ? Should i use a software like PGPool ? Will the connection pooling boost considerably the performance ?Leonel adviced me to use persistent connections ? hos do i use that ?PS: I am using PHP for my applications.ThanksNajibTalha Khan [EMAIL PROTECTED]
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apache is our web server.The performance of my application drops down when a large numbers of users connects at the same time. I need to have a better response time ! That's
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apache is our web server.The performance of my application drops down when a large numbers of users connects at the same time. I need to have a better response time ! That's
You should also consider using connection pooling inorder to attain better performance.
Regards
Talha Khan
On 9/20/06, Najib Abi Fadel [EMAIL PROTECTED] wrote:
I have a web application that is accessed by a large number of users. My application is written in PHP and uses postgres. Apache is our
The solution you need all depends on the problem you are having. If you
explain how your application is written PHP, Java, etc and where your
performance problems are coming from, then someone could give you a better
answer!
Regards,
Ben
Najib Abi Fadel [EMAIL PROTECTED] wrote in message
Robin Ericsson [EMAIL PROTECTED] wrote: On 9/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote: Hi, i was searching for a load balancing solution for postgres, I found some ready to use software like PGCluster, Slony, pgpool and others. It would really be nice if someone knows which one is the best
On 9/18/06, Najib Abi Fadel [EMAIL PROTECTED] wrote:
Hi,
i was searching for a load balancing solution for
postgres, I found some ready to use software like
PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is
the best taking in consideration that i have
Hi,
i was searching for a load balancing solution for
postgres, I found some ready to use software like
PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is
the best taking in consideration that i have an
already running application that i need to load
11 matches
Mail list logo