Re: What is the Best Postgresql Load Balancing Solution available ? - Mailing list pgsql-general
From | Nikolay Samokhvalov |
---|---|
Subject | Re: What is the Best Postgresql Load Balancing Solution available ? |
Date | |
Msg-id | e431ff4c0609251317w3fbde299y58f832f8319d5065@mail.gmail.com Whole thread Raw |
In response to | Re: What is the Best Postgresql Load Balancing Solution available ? (Najib Abi Fadel <nabifadel@yahoo.com>) |
Responses |
Re: What is the Best Postgresql Load Balancing Solution
("Joshua D. Drake" <jd@commandprompt.com>)
|
List | pgsql-general |
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 can help you monitoring your database, pgFouine: http://pgfouine.projects.postgresql.org/. I recommend it highly, it really helps to understand what queries are "bottle neck" of your system and when (the time of the day) the load reaches maximum. Good luck. On 9/21/06, Najib Abi Fadel <nabifadel@yahoo.com> wrote: > 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@gmail.com> wrote: > > You should also consider using connection pooling inorder to attain better > performance. > > Regards > Talha Khan > > > On 9/20/06, Najib Abi Fadel <nabifadel@yahoo.com> 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@_nospam_mowlem.com> 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@web38301.mail.mud.yahoo.com... > > > > > > > > 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@postgresql.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. > > -- Best regards, Nikolay
pgsql-general by date: