On Wed, 2006-09-27 at 00:22, Najib Abi Fadel wrote:
> 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 ?
pg_pconnect isn't "pooling" per se. In pooling, a large number of
processes share a small num
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" <[EMAIL PROTECTED]> wrote: Nikolay Samokhvalov wrote:> As for persistent connection with PHP, start from here:> http://php.net/pg_p
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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...Hi
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
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
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.ThanksNajibTalha Khan <[EMAIL PROTECTED]> wro
You should also consider using connection pooling inorder to attain better performance.
Regards
Talha Khan
On 9/20/06, Najib Abi Fadel <[EMAIL PROTECTED]> 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
On Wed, 2006-09-20 at 00:46 -0700, 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 connec
> 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
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 w
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 w
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" <[EMAIL PROTECTED]> wrote in message
Robin Ericsson <[EMAIL PROTECTED]> wrote: On 9/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> 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>
On 9/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> 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
14 matches
Mail list logo
