On Fri, Jul 5, 2013 at 3:01 PM, Josh Berkus <j...@agliodbs.com> wrote: > On 07/05/2013 12:26 PM, Tom Lane wrote: >> ivan babrou <ibob...@gmail.com> writes: >>> If you can figure out that postgresql is overloaded then you may >>> decide what to do faster. In our app we have very strict limit for >>> connect time to mysql, redis and other services, but postgresql has >>> minimum of 2 seconds. When processing time for request is under 100ms >>> on average sub-second timeouts matter. >> >> If you are issuing a fresh connection for each sub-100ms query, you're >> doing it wrong anyway ... > > It's fairly common with certain kinds of apps, including Rails and PHP. > This is one of the reasons why we've discussed having a kind of > stripped-down version of pgbouncer built into Postgres as a connection > manager. If it weren't valuable to be able to relocate pgbouncer to > other hosts, I'd still say that was a good idea.
for the record, I think this is a great idea. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers