Re: 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 <nabifadel(at)yahoo(dot)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(dot)amjad(at)gmail(dot)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(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.
> >
> >
>
>
>
>
> ________________________________
> Do you Yahoo!?
> Next-gen email? Have it all with the all-new Yahoo! Mail.
>
>

--
Best regards,
Nikolay