postgres_fdw and connection management - Mailing list pgsql-hackers

From Sandro Santilli
Subject postgres_fdw and connection management
Date
Msg-id 20140523110907.GF6655@localhost
Whole thread Raw
Responses Re: postgres_fdw and connection management
List pgsql-hackers
I'm evaluating use of the postgres FDW to keep in sync a central database
to changes made in thousand other databases, via triggers.

But as long as postgres_fdw keeps connections open for the whole lifetime
of a session this conflicts with large use of poolers which make sessions
virtually never expire.

Is there any way to ask the postgres_fdw to close connections at the
end of a transaction ? Or would it be possible at all to do from a 
FDW handler ? Do you see any drawback in doing that ?

I'm willing to work on a patch, maybe accepting an additional OPTION,
if you agree on the idea.

--strk;
()  ASCII ribbon campaign  --  Keep it simple !/\  http://strk.keybit.net/rants/ascii_mails.txt  



pgsql-hackers by date:

Previous
From: Shigeru Hanada
Date:
Subject: fix worker_spi to run as non-dynamic background worker
Next
From: Robert Haas
Date:
Subject: Re: -DDISABLE_ENABLE_ASSERT