[GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 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
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 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 basedon 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 settingsDid 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! Messengers low PC-to-Phone call rates.
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 news:[EMAIL PROTECTED] Robin Ericsson <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]Robin Ericsson <[EMAIL PROTECTED]> 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 basedon 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 settingsDid 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly Get your email and more, right on the new Yahoo.com
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]Robin Ericsson <[EMAIL PROTECTED]> 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 basedon 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 settingsDid 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] 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 basedon 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 settingsDid 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 appropriatesubscribe-nomail command to [EMAIL PROTECTED] so that yourmessage can get through to the mailing list cleanly How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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]> wrote: 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 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] 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 basedon 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 settingsDid 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 appropriatesubscribe-nomail command to [EMAIL PROTECTED] so that yourmessage 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.
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: 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 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > > > 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 [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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 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]> wrote: 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 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] 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 basedon 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 settingsDid 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 appropriatesubscribe-nomail command to [EMAIL PROTECTED] so that yourmessage 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.
Re: [GENERAL] What is the Best Postgresql Load Balancing Solution available ?
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:> http://php.net/pg_pconnect.Uhmmm no.Start here: http://pgpool.projects.postgresql.org/pg_pconnect tends to have a host of issues.Joshua D. Drake> > 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: 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 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]>> >>> >>> >>> > 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 [EMAIL PROTECTED] 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.> > -- === The PostgreSQL Company: Command Prompt, Inc. ===Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail.