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.
I would also like to know if someone has used Red Hat
Cluster and GFS for implementing postgresql Load
balancing solution. I have alreay used that for
implementing a mail load balancing solution with 2
sendmail servers running on 2 different machines but
sharing the same storage.
Thanks for any help.
Najib Abi Fadel
System Administrator
Saint-Joseph University
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
(end of broadcast)
TIP 4: Have you searched our list archives?
http://archives.postgresql.org

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" <nabifadel (AT) yahoo (DOT) comwrote in message @web38303.mail.mud.yahoo.com
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 (AT) gmail (DOT) comwrote:
You should also consider using connection pooling inorder to attain better performance.

Regards
Talha Khan

9/20/06, Najib Abi Fadel <nabifadel (AT) yahoo (DOT) comwrote:
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 (AT) _nospam_mowlem (DOT) comwrote:
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

@web38301.mail.mud.yahoo.com

Robin Ericsson wrote:
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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.

Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail.