Re: Millisecond-precision connect_timeout for libpq - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Millisecond-precision connect_timeout for libpq
Date
Msg-id 51D7280D.2050705@commandprompt.com
Whole thread Raw
In response to Re: Millisecond-precision connect_timeout for libpq  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Millisecond-precision connect_timeout for libpq
List pgsql-hackers
On 7/5/2013 1:01 PM, Josh Berkus wrote:
> 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.

No kidding. I think a lot of -hackers forget that the web rules here and 
the web is stateless, which means a huge performance loss for postgresql 
unless we add yet another piece of software. Pre-forking here would 
really help us.

JD





pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: sepgsql and materialized views
Next
From: Jeff Davis
Date:
Subject: Re: Eliminating PD_ALL_VISIBLE, take 2