---
title: "#241: Principles and Applications of Postgres's Index Types"
publication: "Postgres Weekly"
issue: 241
published_at: "2018-01-31"
canonical_url: "https://postgresweekly.com/issues/241"
---

Postgres Weekly 241   . 

[Read this on the Web](http://postgresweekly.com/issues/241) 

[Postgres Weekly](http://postgresweekly.com) Issue 241 — January 31, 2018     

[DO or UNDO - There Is No VACUUM](http://rhaas.blogspot.co.uk/2018/01/do-or-undo-there-is-no-vacuum.html)What if Postgres didn’t need VACUUM at all? This seems hard to imagine, but some folks at EnterpriseDB are investigating the possibility. Robert Haas [Principles and Applications of Postgres's Index Types](https://medium.com/@Alibaba_Cloud/principles-and-applications-of-the-index-types-supported-by-postgresql-481f59bab67d)Explanation, links, and examples of B-trees, hashes, GIN, GiST, SP-GiST, BRIN, RUM, Bloom filter, bitmap and other types. Alibaba Cloud [Using Table Partitioning for Storing Logs in Postgres](https://engineering.semantics3.com/partitioning-in-postgresql-161e52c367ba)Using table partitioning to support an idea akin to ‘rotating’ log files, but with logs stored in Postgres. Arpit Agarwal [Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP)Collect out-of-the-box and custom Postgres metrics and correlate them with data from across your distributed infrastructure and applications. Gain real-time performance insights and set intelligent alerts with Datadog. [Try it free](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP). Datadog#sponsored[![\](https://copm.s3.amazonaws.com/9c3a43fe.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) [Postgres Indexes Under the Hood](https://rcoh.me/posts/postgres-indexes-under-the-hood/)An accessible introduction to B-tree indexes and how they work. Russell Cohen [Upcoming Enhancements to Partitioning and Indexes in PG 11](https://blog.2ndquadrant.com/enhancements-to-partitioning-and-indexes-in-postgresql-11/)A very brief overview: _“PostgreSQL 11 is looking like we’ll be able to add referential integrity to partitioned tables.”_ Simon Riggs#news [Citus 7.2: Distributed Postgres W/ CTEs, Complex Subqueries, Set Operations, and More](https://www.citusdata.com/blog/2018/01/26/citus-7-2-ctes-complex-subqueries-set-operations/)The Citus 7.2 extension to Postgres now includes distributed database features such as expanded support for distributed SQL and the distribution of complex subqueries across multiple nodes, and more. citusdata#news [PostgresConf US 2018 Earlybird Reg Ends.. Today (31st)](https://postgresconf.org/blog/posts/postgresconf-us-2018-early-bird-registration-ends-on-january-31st) PGConf#news [PGDay.IT 2018: Call for Papers and Call for Workshops](https://www.postgresql.org/about/news/1826/)Taking place on Lake Garda, Italy, on June 29th. postgresql.​org#news [Citus and pg_partman: Creating a Scalable Time Series Database](https://www.citusdata.com/blog/2018/01/24/citus-and-pg-partman-creating-a-scalable-time-series-database-on-PostgreSQL/)pg_partman is a ‘best in class’ extension for improving time-based partitioning on Postgres and here’s how to use it with a Citus cluster. Citus Data [How We Built A Multi-Tenant Job Queue System with PG & Ruby](https://blog.holistics.io/how-we-built-a-multi-tenant-job-queue-system-with-postgresql-ruby/) Huy Nguyen [Avoiding Unnecessary Stored Procedure Calls in Postgres](https://www.cybertec-postgresql.com/en/avoiding-unnecessary-stored-procedure-calls-in-postgresql/)It’s possible to write stored procedures in almost any language. When it comes to slow procedures Postgres often isn’t to blame, and here’s why. Hans-Juergen Schoenig [How A Bad Network Configuration Can Cause Table Bloat](https://www.cybertec-postgresql.com/en/stale-statistics-cause-table-bloat/) Laurenz Albe [Demystifying Postgres Logical Replication](https://learn.percona.com/2018-cp-demystifying-postgres-logical-replication-recording) Percona#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/241) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK