Combine these tips with those: https://tech.fretlink.com/build-your-own-data-lake-for-repor... (I'm the writer of that linked article) and you get a really powerful, fully open-source, extensive data-warehouse solution for many real-life use cases (when your data doesn't exceed the 10^9 order of magnitude for number of rows).
Thanks Cedric for sharing your experience with using PG for data-warehousing <3
Thanks Cedric for sharing your experience with using PG for data-warehousing <3