On Mon, May 26, 2014 at 10:47 PM, Shigeru Hanada
wrote:
> 2014-05-24 0:09 GMT+09:00 Sandro Santilli :
>> 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
On Tue, May 27, 2014 at 12:32:50AM -0300, Fabrízio de Royes Mello wrote:
> On Mon, May 26, 2014 at 11:47 PM, Shigeru Hanada
> wrote:
> >
> > 2014-05-24 0:09 GMT+09:00 Sandro Santilli :
> > > Indeed I tried "DISCARD ALL" in hope it would have helped, so I find
> > > good your idea of allowing exten
On Mon, May 26, 2014 at 11:47 PM, Shigeru Hanada
wrote:
>
> 2014-05-24 0:09 GMT+09:00 Sandro Santilli :
> > 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 po
2014-05-24 0:09 GMT+09:00 Sandro Santilli :
> 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-spe
On Fri, May 23, 2014 at 11:13:50AM -0300, Fabrízio de Royes Mello wrote:
> On Fri, May 23, 2014 at 8:09 AM, Sandro Santilli wrote:
> >
> > 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
On Fri, May 23, 2014 at 8:09 AM, Sandro Santilli wrote:
>
> 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 confl
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 e
