#241: Principles and Applications of Postgres's Index Types

.

Read this on the Web

Postgres Weekly Issue 241 — January 31, 2018

DO or UNDO - There Is No VACUUM 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 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 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 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. Datadog    #sponsored  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 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 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) PGConf   #news  PGDay.IT 2018: Call for Papers and Call for Workshops Taking place on Lake Garda, Italy, on June 29th. postgresql.​org   #news  Citus and pg_partman: Creating a Scalable Time Series Database 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 Huy Nguyen Avoiding Unnecessary Stored Procedure Calls in Postgres 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 Laurenz Albe Demystifying Postgres Logical Replication Percona    #sponsored  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK