At Narrator we support many data warehouses, including Postgres. Though it was designed for production systems, with a little tweaking Postgres can work extremely well as a data warehouse.

For those that want to cut to the chase, here’s the tl;dr

• don’t use the same server as your production system
• upgrade to pg 12+ (or avoid common table expressions in your queries)
• go easy on indexes – less is more
• consider partitioning long tables
• ensure you’re not I/O-bound
• vacuum analyze after bulk insertion
• explore parallel queries
• increase statistics sampling
• use fewer columns on frequently-queried tables
• at scale consider a dedicated warehouse

Read in full here:

This thread was posted by one of our members via one of our news source trackers.