Re: Strategy for materialisation and centralisation of data - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Strategy for materialisation and centralisation of data
Date
Msg-id 20200521205652.GC317@hermes.hilbert.loc
Whole thread Raw
In response to Re: Strategy for materialisation and centralisation of data  (Rory Campbell-Lange <rory@campbell-lange.net>)
List pgsql-general
On Thu, May 21, 2020 at 09:52:02PM +0100, Rory Campbell-Lange wrote:

> > Might postgres_fdw help in any way ?
>
> Thanks for the suggestion. As I noted we are already using pl/proxy and
> it works well, although we are soaking up a lot of connections with it.
> >From my reading of the postgres_fdw docs it is much more featureful than
> pl/proxy but it is likely to have the same connection characteristics.
>
> The main issues we're trying to solve is standardising data access
> through (I think) materialisation and centralisation.

While plausible I still would not be entirely surprised if
testing were to reveal something different.

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B



pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: Strategy for materialisation and centralisation of data
Next
From: Zahir Lalani
Date:
Subject: RE: Should I use JSON?