Re: posgres tunning - Mailing list pgsql-general

From phoenix.kiula@gmail.com
Subject Re: posgres tunning
Date
Msg-id 1187525194.105497.16550@i38g2000prf.googlegroups.com
Whole thread Raw
In response to Re: posgres tunning  ("Gavin M. Roy" <gmr@myyearbook.com>)
Responses Re: posgres tunning
List pgsql-general
On Jul 23, 5:18 am, g...@myyearbook.com ("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 an application developed in PHP or
Perl? It would be lovely if you can share some info about this
seemingly useful app which comes with so little documentation on how
to actually get using. The Skype site mentions the install bits, but
not how to actually query the pgBouncer stuff instead of the database.
Very hard to come by some actual code. Could you please share some?
Many thanks!


pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Seeking datacenter PITR backup procedures [RESENDING]
Next
From: Karsten Hilbert
Date:
Subject: Re: SUBSTRING performance for large BYTEA