Re:Using PostgreSQL as a Data Warehouse
by phibz on Tuesday May 25, 2021 @11:23AM
(#27278035)
Yes you understood correctly, 20 TB on a single node. And this was in 2007. The data was email and direct mail campaign and response data.
Typically only the more recent data was analyzed.
We retained all source data sou that reprocessing could happen when adding facts or dimensions.
Analysis, scheduled or ad hoc, only ever happened against the data cubes. Their partial aggregate nature along with partitioning was part of how the performance was so good.
Typically only the more recent data was analyzed.
We retained all source data sou that reprocessing could happen when adding facts or dimensions.
Analysis, scheduled or ad hoc, only ever happened against the data cubes. Their partial aggregate nature along with partitioning was part of how the performance was so good.