Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.