On 2018-04-19 15:01:24 -0400, Tom Lane wrote: > Only after you can say "there's nothing wrong with this that isn't > directly connected to its not being in-core" does it make sense to try > to push the logic into core.
I think there's plenty things that don't really make sense solving outside of postgres: - additional added hop / context switches due to external pooler - temporary tables - prepared statements - GUCs and other session state I think there's at least one thing that we should attempt to make easier for external pooler: - proxy authorization I think in an "ideal world" there's two kinds of poolers: Dumb ones further out from the database (for short lived processes, keeping the total number of connections sane, etc) and then more intelligent one closer to the database. Greetings, Andres Freund