|
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
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.
Thanks
Najib
Talha Khan
<talha.amjad@xxxxxxxxx> wrote:
You should also consider using connection pooling inorder to attain
better performance.
Regards
Talha Khan
On 9/20/06, Najib Abi
Fadel <nabifadel@xxxxxxxxx> 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 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 why i need to
load balance the web requests and the database.
Regards,
Najib.
Ben Trewern
<ben.trewern@xxxxxxxxxxxxxxxxxx> wrote:
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" wrote in message
news:20060919053331.34790.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Robin Ericsson wrote:
On
9/18/06, Najib Abi Fadel 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 an
> already
running application that i need to load
> balance.
There
isn't one tool that is the best, all three work very good based
on
where they are used and what they are used for.
--
regards,
Robin
---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase
your free space map settings
Did you try them or have any
experience with them. I need them for load
balancing my database and
thus making the queries faster. I have a web
application heavely using
a postgres database. Hundreds of users can connect
at the same time to
my web application.
Thanks in advance for any
help.
Najib.
How low will we go? Check
out Yahoo! Messenger's low PC-to-Phone call rates.
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through
Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get
through to the mailing list cleanly
Do you Yahoo!?
Next-gen email? Have it all with the all-new
Yahoo! Mail.
|
