
Scaling Postgres Episode 17 | Real Time Analytics | Index Decrease Performance | work_mem
Get New Episodes Weekly!
In this episode of Scaling Postgres, we review articles covering using Postgres for real-time analytics, how indexes can decrease performance and how to configure work_mem.
Content Discussed
- Scalable incremental data aggregation on Postgres and Citus
- Adding an index can decrease SELECT performance
- Materialized views with PostgreSQL for beginners
- Configuring memory for Postgres
- Using Window Functions for Time Series IoT Analytics in Postgres-BDR
- How Redshift differs from PostgreSQL
- Deploying PostgreSQL on a Docker Container