Re: 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" <nabifadel(at)yahoo(dot)com> wrote in message news:20060921082248(dot)96629(dot)qmail(at)web38303(dot)mail(dot)mud(dot)yahoo(dot)com(dot)(dot)(dot)
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.