---
title: "Materialized Views vs. Rollup Tables in Postgres"
publication: "Postgres Weekly"
issue: 281
published_at: "2018-11-07"
canonical_url: "https://postgresweekly.com/issues/281"
---

The latest Postgres news, articles, tools, and projects.       

#281 — November 7, 2018 

[Read on the Web](https://postgresweekly.com/issues/281)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/zipij3kx5izdatpiprmc.jpg)](https://blog.2ndquadrant.com/omnidb-debugger-postgresql-11/)  

[Debugging Postgres 11 Procedures with OmniDB Debugger](https://blog.2ndquadrant.com/omnidb-debugger-postgresql-11/) — [OmniDB](https://www.2ndquadrant.com/en/resources/omnidb/) is an open source, interactive database management tool and it already has support for debugging Postgres 11 procedures as demonstrated here. 

2ndQuadrant   

[Materialized Views vs. Rollup Tables in Postgres](https://www.citusdata.com/blog/2018/10/31/materialized-views-vs-rollup-tables/) — Materialized views are often used to make reporting faster, however another approach (rollup tables) can have some advantages while delivering the same benefits. 

Craig Kerstiens   [![\](https://copm.s3.amazonaws.com/f6128eec.png)](http://www.2qpgconf.com) 

[2Q PGConf 2018 - Hands-on PostgreSQL Training with Experts](http://www.2qpgconf.com) — Get hands-on PostgreSQL training with local experts at 2Q PGConf 2018 in Chicago on December 4. Courses include: PostgreSQL Database Security, PostgreSQL Multi-master Replication, & PostgreSQL Performance Tuning. Special discounted rate for this date. 

2ndQuadrant PostgreSQL Events sponsor   

[How to Create a Single Endpoint for a Replication Setup with HAProxy](https://severalnines.com/blog/how-create-single-endpoint-your-postgresql-replication-setup-using-haproxy) — PostgreSQL clients usually talk to a single endpoint, but what happens when you use a replication setup? HAProxy (a genuinely amazing TCP and HTTP proxy) can be used to distribute traffic quite easily. 

Sebastian Insausti   

[TimescaleDB 1.0 Now Production Ready](https://blog.timescale.com/1-0-enterprise-production-ready-time-series-database-open-source-d32395a10cbf) — We mentioned the release candidate several weeks ago, but the time-series database built on top of Postgres (as an extension) is now truly production ready. 

Mike Freedman   

['Killed Index Tuples': A Little Known Performance Feature](https://www.cybertec-postgresql.com/en/killed-index-tuples/) — Describes ‘killed index tuples’, a little-known feature that can help explain variations in index scan execution time. 

Laurenz Albe (Cybertec)   

[Setting Up a RESTful API with Express.js and Postgres](https://blog.logrocket.com/setting-up-a-restful-api-with-node-js-and-postgresql-d96d6fc892d8) — A nice straightforward tutorial aimed at beginners. 

Tania Rascia   

[Tracking Foreign Keys Throughout a Schema](https://blog.hagander.net/tracking-foreign-keys-throughout-a-schema-242/) — An efficient way to track down key usage where naming standards for using the key had not always been followed. 

Magnus Hagander   

[A Tip When Using Makefiles to Build PostgreSQL](https://andreas.scherbaum.la/blog/archives/964-Using-Makefiles-to-build-PostgreSQL.html) — Quite an edge case but if you’ve run into trouble with using Make to trigger Postgres builds, this tip could save you some headaches. 

Andreas Scherbaum   

[Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyS) — Correlate PostgreSQL metrics with data from your distributed infrastructure, applications, and logs. Start a free trial. 

Datadog sponsor   

[Slonik: A Node.js Postgres Client with Strict Types, Detail Logging and Assertions](https://github.com/gajus/slonik) — Built on top of the `pg` library, Slonik provides more niceties and convenience methods. 

Gajus Kuizinas  

🗓 Events  

[Pg Down Under 2018](https://2018.pgdu.org/) — **December 7 (Melbourne, Australia)** PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.   

[PGConf.ASIA 2018](https://www.pgconf.asia/EN/2018/) — **December 10-12 (Tokyo, Japan)** The largest PostgreSQL event in Asia.   

[FOSDEM PGDay 2019](https://2019.fosdempgday.org/) — **February 1, 2019 (Brussels, Belgium)** An extension to the regular PostgreSQL activities at FOSDEM.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom