Re: [GENERAL] posgres tunning

2007-08-19 Thread Gavin M. Roy
We use PHP, but think of it as a universal PgSQL proxy.. If you connect to a connection you setup in pgBouncer via psql, it looks like a normal database. Nothing is different in your code but where you connect (for us, it's the same as our core DB server on a different server). Let me know if t

Re: [GENERAL] posgres tunning

2007-08-19 Thread Phoenix Kiula
On 19/08/07, Gavin M. Roy <[EMAIL PROTECTED]> wrote: > We use PHP, but think of it as a universal PgSQL proxy.. If you connect to > a connection you setup in pgBouncer via psql, it looks like a normal > database. Nothing is different in your code but where you connect (for us, > it's the same as

Re: [GENERAL] posgres tunning

2007-08-19 Thread [EMAIL PROTECTED]
On Jul 23, 5:18 am, [EMAIL PROTECTED] ("Gavin M. Roy") wrote: > You might want to look at pgBouncer to pool your drupal pgsql needs. I've > found with 2000 needed connections, I can pool out to only 30 backends and > still push 8k transactions per second. > How you do use pgBouncer -- through a

Re: [GENERAL] posgres tunning

2007-07-22 Thread Gavin M. Roy
You might want to look at pgBouncer to pool your drupal pgsql needs. I've found with 2000 needed connections, I can pool out to only 30 backends and still push 8k transactions per second. On 7/21/07, Arnaldo Gandol <[EMAIL PROTECTED]> wrote: I have a drupal site working with postgres that do

Re: [GENERAL] posgres tunning

2007-07-21 Thread Michael Fuhr
On Sat, Jul 21, 2007 at 09:54:35PM -0500, Arnaldo Gandol wrote: > I have a drupal site working with postgres that does not tolerate more > than 200 concurrent connections(it is not hardware fault). What does "not tolerate" mean? Does the database refuse connections beyond 200? Does it permit co