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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://www.citusdata.com/blog/2018/06/14/scalable-incremental-data-aggregation/
- https://www.cybertec-postgresql.com/en/index-decreases-select-performance/
- https://medium.com/jobteaser-dev-team/materialized-views-with-postgresql-for-beginners-9809483db35f
- https://www.citusdata.com/blog/2018/06/12/configuring-work-mem-on-postgres/
- https://blog.2ndquadrant.com/window-functions-time-series-iot-analytics-postgres-bdr/
- https://www.stitchdata.com/blog/how-redshift-differs-from-postgresql/
- https://severalnines.com/blog/deploying-postgresql-docker-container