Re: 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 <nabifadel(at)yahoo(dot)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(dot)trewern(at)_nospam_mowlem(dot)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(dot)34790(dot)qmail(at)web38301(dot)mail(dot)mud(dot)yahoo(dot)com(dot)(dot)(dot)
>
>
> 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(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.
> <http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
>
>