Search Postgresql Archives

Re: What is the Best Postgresql Load Balancing Solution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <nabifadel@xxxxxxxxx> 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@xxxxxxxxx> wrote:

You should also consider using connection pooling inorder to attain better
performance.

Regards
Talha Khan


On 9/20/06, Najib Abi Fadel <nabifadel@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
>
>
> 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@xxxxxxxxxxxxxx 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.2240
   Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux