Re: Separate connection handling from backends

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <stark(at)mit(dot)edu>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Separate connection handling from backends
Date: 2016-12-07 06:41:18
Message-ID: e2c572b7-eca3-94a7-4146-f3cbc6c1ab2b@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/6/16 10:34 PM, Craig Ringer wrote:
> In other words, we could start to separate session state from executor
> state in a limited manner. That'd definitely be valuable, IMO; it's a
> real shame that Pg's architecture so closely couples the two.
>
> So - is just doing "PgInCoreBouncer" a good idea? No, I don't think
> so. But there are potentially good things to be done in the area.

Right.

> What I don't see here is a patch, or a vague proposal for a patch, so
> I'm not sure how this can go past the hot-air stage.

Yeah, I brought it up because I think there's potential tie-in with
other things that have been discussed (notably async transactions, but
maybe BG workers and parallel query could benefit too). Maybe it would
make sense as part of one of those efforts.

Though, this is something that's asked about often enough that it'd
probably be possible to round up a few companies to fund it.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-12-07 06:44:14 Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)
Previous Message Craig Ringer 2016-12-07 06:39:47 Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)