Best of PostgreSQL — November 2023

1. 1
   Article

   TigerData (Creators of TimescaleDB)·3y

   How We Scaled PostgreSQL to 350 TB+ (With 10B New Records/Day)

   Insights is a tool in the Timescale platform that allows users to analyze their query performance. They collected query information by instrumenting the databases and storing the records in a single Timescale service. They faced challenges in ingesting and querying large amounts of data, and storing hundreds of TBs in a single Timescale service. Despite the challenges, TimescaleDB proved to be scalable and efficient.

   14
2. 2
   Article

   Hacker News·3y

   Building a Streaming Platform in Go for Postgres

   PeerDB has transitioned from a pull-and-push model to a more efficient streaming approach using Go channels. This change has significantly improved performance, reduced latency, and created a more responsive system. PeerDB is exploring future enhancements, such as spilling the record stream to disk to prevent Out-of-Memory (OOM) issues.

   13

   1
3. 3
   Article

   TigerData (Creators of TimescaleDB)·3y

   Top 5 PostgreSQL Extensions

   Discover the top 8 PostgreSQL extensions that enhance database functionality and performance. Learn how to list and install extensions, and explore sample queries for each extension.

   12