• Robert Haas's avatar
    Avoid multiple foreign server connections when all use same user mapping. · 96198d94
    Robert Haas authored
    Previously, postgres_fdw's connection cache was keyed by user OID and
    server OID, but this can lead to multiple connections when it's not
    really necessary.  In particular, if all relevant users are mapped to
    the public user mapping, then their connection options are certainly
    the same, so one connection can be used for all of them.
    
    While we're cleaning things up here, drop the "server" argument to
    GetConnection(), which isn't really needed.  This saves a few cycles
    because callers no longer have to look this up; the function itself
    does, but only when establishing a new connection, not when reusing
    an existing one.
    
    Ashutosh Bapat, with a few small changes by me.
    96198d94
postgres_fdw.h 3.85 KB