From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com> |
Cc: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: postgres_fdw and connection management |
Date: | 2014-05-30 03:42:21 |
Message-ID: | CA+TgmoZFto0QzqzqJyy7HFoyGhUhRBW0YJ5vtjOvhWneJzFeHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, May 26, 2014 at 10:47 PM, Shigeru Hanada
<shigeru(dot)hanada(at)gmail(dot)com> wrote:
> 2014-05-24 0:09 GMT+09:00 Sandro Santilli <strk(at)keybit(dot)net>:
>> Indeed I tried "DISCARD ALL" in hope it would have helped, so I find
>> good your idea of allowing extensions to register an hook there.
>>
>> Still, I'd like the FDW handler itself to possibly be configured
>> to disable the pool completely as a server-specific configuration.
>
> Connection management seems FDW-specific feature to me. How about to
> add FDW option, say pool_connection=true|false, to postgres_fdw which
> allows per-server configuration?
Right... or you could have an option to close the connection at
end-of-statement, end-of-transaction, or end-of-session. But quite
apart from that, it seems like there ought to be a way to tell an FDW
to flush its state.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2014-05-30 05:00:42 | Re: pg_sleep() doesn't work well with recovery conflict interrupts. |
Previous Message | Robert Haas | 2014-05-30 03:39:46 | Re: Spreading full-page writes |