Online DW

From: Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, PostgreSQL-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Online DW
Date: 2016-06-10 08:11:06
Message-ID: CAGuFTBUXERhBcN+bNBCcxzCP6u_C3Ad3Sh0WdUUqpXN=fchnzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi

Is there any feature in PostgreSQL where online DW (Dataware housing) is
possible ?

am looking for scenario like

1. Production DB will have CURRENT + LAST 7 DAYS data only

2. Archive/DW DB will have CURRENT + COMPLETE HISTORY

expecting something like streaming, but not ETL

Thanks
Sridhar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-06-10 08:24:33 Re: Online DW
Previous Message Michael Paquier 2016-06-10 05:22:35 Re: Retrieving comment of rules and triggers

Browse pgsql-hackers by date

  From Date Subject
Next Message John R Pierce 2016-06-10 08:24:33 Re: Online DW
Previous Message Noah Misch 2016-06-10 07:10:40 Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?