| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, PostgreSQL-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Online DW |
| Date: | 2016-06-10 08:52:58 |
| Message-ID: | CAMsr+YGraKxmMvuRBQSZ53_hXv07Emw0sK7Nq8RWQ_EMcTzThg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 10 June 2016 at 16:11, Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
wrote:
> 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
>
There's nothing built-in, but that's exactly the sort of thing pglogical is
intended for. You can also build something along those lines with Londiste
fairly easily.
Hopefully this is the sort of thing we can move toward with built-in
logical replication in coming releases.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sridhar N Bamandlapally | 2016-06-10 09:18:22 | Re: [HACKERS] Online DW |
| Previous Message | John R Pierce | 2016-06-10 08:24:33 | Re: Online DW |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2016-06-10 08:55:19 | Re: [sqlsmith] Failed assertion in postgres_fdw/deparse.c:1116 |
| Previous Message | Masahiko Sawada | 2016-06-10 08:46:44 | Re: Reviewing freeze map code |