Using PostgreSQL as a data warehouse

From: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Using PostgreSQL as a data warehouse
Date: 2021-07-14 06:15:25
Message-ID: kHdeJgBqEuIMNCQQ6VRcDRTRyCk955dVmzsUeBrl-pGHvlEJZSebgMuetjrF5lcIP3GRyT1azWPgs9cbm5qTI6pcmwhUXXeoA7E55lO2nuw=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I know there are projects out there to turn PostgreSQL into a data warehouse. Still, I wondered how the community at large handled storing lots of data around analytics and other things of that nature. I was thinking about dumping it all into JSONB and when I had more of a grip on the data moving it to a proper SQL table.

Does anyone have any tips for me at all? I'm running the latest version, 13.3.

Thank you.

Simon.

Browse pgsql-novice by date

  From Date Subject
Next Message DAVID ROTH 2021-07-19 18:20:36 Nested Procedures
Previous Message Laurenz Albe 2021-06-28 13:33:05 Re: server.crt Missing