Re: Oh, this is embarrassing: init file logic is still broken

On 06/25/2015 11:04 AM, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> On 06/25/2015 08:12 AM, Tom Lane wrote:
>>> I can't see doing a release just for this. If we were due for releases
>>> anyway, sure, but we've considerably overstressed our poor packagers of
>>> late. Previous discussion was to the effect that we'd anticipate another
>>> set of releases in a month or so, after some more multixact fixes have
>>> landed.
>
>> FWIW, I know users who will not update because of this regression.
>> Consider applications which regularly need to spin up 200 new
>> connections in 90 seconds due to usage peaks.
>
> TBH, if your app is critically dependent on backend startup time,
> You're Doing It Wrong, because that means you're pissing away significant
> performance by not using a connection pooler. So I don't have a huge
> amount of sympathy.

Most of these apps are using a connection pooler. But usage is very
spiky, and one doesn't want to keep around 300 idle connections all the
time for the 5 minutes when you need them. Indeed, pgbouncer is
configured to spin down idle connections after a configured amount of
time idle, as are most connection poolers.

Regardless, I don't think it's a good idea to release again sooner than
planned. It is a good reason to look at making connection creation time
a regular test, though; you can be sure I'll be testing 9.4.5 and 9.5a!

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com