Re: What is the Best Postgresql Load Balancing Solution available ?

[Najib Abi Fadel <nabifadel@xxxxxxxxx>]

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" <jd@xxxxxxxxxxxxxxxxx> 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 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 wrote:
>>
>> You should also consider using connection pooling inorder to attain
>> better
>> performance.
>>
>> Regards
>> Talha Khan
>>
>>
>> On 9/20/06, Najib Abi Fadel 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 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/

---

Do you Yahoo!?
 Everyone is raving about the  all-new Yahoo! Mail.