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

From Rory Campbell-Lange
Subject Re: Strategy for materialisation and centralisation of data
Date
Msg-id 20200521211921.GA8702@campbell-lange.net
Whole thread Raw
In response to Re: Strategy for materialisation and centralisation of data  (Michael Stephenson <domehead100@gmail.com>)
List pgsql-general
On 21/05/20, Michael Stephenson (domehead100@gmail.com) wrote:
> On Thu, May 21, 2020 at 10:36 AM Rory Campbell-Lange wrote

> > Presently I've been thinking of using triggers or materialized views in
> > each database to materialise data into a "matview" schema which is then
> > shipped via logical replication to an organisation database when
> > required. New columns in the matview schema tables would ensure replica
> > identity uniqueness and allow the data to be safely stored in common
> > tables in the organisation database.

> You might find Materialize interesting:
> 
> https://materialize.io/

Hi Michael. Thanks for the pointer. Materialize.io seems cool but we
don't deal with streaming data, or am I missing something?

Cheers
Rory



pgsql-general by date:

Previous
From: Michael Stephenson
Date:
Subject: Re: Strategy for materialisation and centralisation of data
Next
From: Christopher Pereira
Date:
Subject: Re: pg_basebackup + incremental base backups