Postgres Weekly
Feed since 17 Mar 2019This feed publishes the latest news and updates on one of the most popular open-source relational database systems in the world. See: http://postgresweekly.com/
To subscribe to and get updates from Postgres Weekly in your feed stream, sign up, or see the rest of our feeds.
Writing a Postgres Logical Replication System in Golang
Creating a Postgres Logical Replication System in Go — The folks behind the (Go-powered) Dolt database...
Path To Citus Con, for developers who love Postgres
▶ The Path to Citus Con: A Podcast for Postgres — The Citus Con event itself is...
How to use pgbench to test PostgreSQL® performance
How to Do Performance Testing with pgbench — A straightforward introduction to using pgbench, a benchmarking...
Hello DBOS - Announcing DBOS Cloud
Postgres Creator Introduces His New Database Startup — MIT professor Mike Stonebraker was a principal architect...
Speed up PostgreSQL® pgvector queries with indexes | EverSQL
Speeding Up pgvector Queries with Indexes — If you’re using Postgres and pgvector to work with...
Enforcing join orders in PostgreSQL
Enforcing Join Orders in Postgres — With SQL being a declarative language, you'd reasonably expect Postgres...
How to use PostgreSQL for (military) geoanalytics tasks · Taras Kloba's
🌐 Using Postgres for (Military) Geoanalytics Tasks — If you dislike military scenarios, skip this, but otherwise...
pgCluu :: PostgreSQL performances monitoring and auditing tool
pgCluu 4.0: Postgres Performance Monitoring and Auditing Tool — A two part tool that collects statistics...
PGConf NYC 2022 Database Disasters and How to Find Them by Christophe Pettus
▶ Database Disasters and How to Find Them — You’re part of an engineering team and you...
Introducing pganalyze Index Advisor 3.0 - A workload-aware system for finding missing indexes in Postgres
pganalyze Index Advisor 3.0: Workload-Aware Index Suggestions — Launched last week, the new advisor finds missing...
Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase
Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase — A reasonably simple, straightforward comparison that doesn’t...
Build a question-answer bot natively using Postgres extensions | Tembo
Building a Q&A Bot Natively with Postgres Extensions — pgvector and embedding models have made it...
GitHub - sraoss/pg_ivm: IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
pg_ivm 1.8: Incremental View Maintenance Extension — IVM can update materialized views incrementally, which is more...
GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation
pg_jsonschema 0.3: JSON Schema Validation Extension — Postgres’s support for JSON / JSONB columns is second...
GitHub - dalibo/pg_activity: pg_activity is a top like application for PostgreSQL server activity monitoring.
pg_activity 3.5: htop-Like Activity Monitoring Tool — Much as you might use top or htop to...
Tips for tuning Postgres LIKE & ILIKE queries via pg_trgm on Azure
Tips for Tuning Postgres LIKE/ILIKE Queries via pg_trgm on Azure — Tips to improve query performance...
Postgres Replication at speed with PeerDB's Sai Srirampur
▶ Discussing Postgres Replication at Speed with PeerDB's Sai Srirampur
The default value of fdw_tuple_cost was updated to 0.2. What does that mean? - Stormatics
The Default Value of fdw_tuple_cost Was Updated to 0.2 – Why? — A quick look at...
The azure_ai extension to Azure Database for PostgreSQL, definition and demo
The azure_ai Extension to Azure Database for PostgreSQL — One benefit of Microsoft’s close relationship with...
GitHub - electric-sql/pglite: Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno
PGlite: Postgres in WebAssembly — People have brought Postgres into WebAssembly contexts before, though usually with...
The State of the Database Landscape 2024
The State of the Database Landscape 2024 — Redgate’s latest survey results show that PostgreSQL continues...
The Rest is History: Investigations of WAL... | Crunchy Data Blog
The Rest is History: Investigations of WAL — Get a deeper insight into just what the...
11 Lessons to learn when using NULLs in PostgreSQL®
11 Lessons to Learn When Using NULLs — NULL represents a missing, unknown or ‘non’-value in...
Understand Indexes in pgvector - Stormatics
The Two Types of Indexes in pgvector — pgvector is a popular extension for working with...
When Less is More: Database Connection Scaling
When Less is More: Database Connection Scaling — The more connections a Postgres server can handle,...
https://people.planetpostgresql.org/devrim/index.php#slesbetter
Installing Postgres on SLES 15 Just Got Easier (and Better) — One for SuSE Enterprise Linux users.
GitHub - jnidzwetzki/pg-lock-tracer: A eBPF based lock tracer for the PostgreSQL database
pg-lock-tracer: An eBPF-Based Lock Tracer — Use eBPF instrumentation to dig into lock-related bottlenecks in Postgres...
pgagroal 1.6.0
pgagroal 1.6: A High Performance Postgres Connection Pool — Introduces support for CLI/JSON output, client certificates,...
pg_dumpbinary v2.15 released
pg_dumpbinary v2.15: Dump a Postgres Database to Binary Format — Rather than produce a SQL dump,...
SQL query optimization: a comprehensive developer's guide
SQL Query Optimization: A Comprehensive Developer's Guide — A bumper packed post digging into the optimization...
pgexporter | pgexporter
pgexporter 0.5: Prometheus Exporter for Postgres — As of v0.5, it’s targeting Postgres 12 and higher...
GitHub - kristiandupont/schemalint: Lint database schemas
Schemalint 1.1: A Linter for Postgres Schemas — A linter that lets you raise errors on...
Release libpqxx 7.9.0: important fixes and new features · jtv/libpqxx
libpqxx 7.9: The Official C++ Client API for Postgres — It’s a pretty big release, says...
PostgreSQL Anonymizer
PostgreSQL Anonymizer: Data Masking for Postgres — Rather than simply anonymizing dumps, say, this extension takes...
Deciphering PostgreSQL Encryption: A Beginner's Guide - Highgo Software Inc.
Deciphering Postgres Encryption: A Beginner's Guide — A (very) casual look at six levels of encryption...
Last Updated Columns With Postgres
Creating 'Last Updated' Columns in Postgres — If you want an automatically updated updated_at timestamp column...
A story of a spectacular success - Intro to AWS RDS database migration series
A Story of a Spectacular Success in Migrating to AWS RDS — Being based on EC2...
What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check
What's Faster? COUNT(*) or COUNT(*) with LIMIT — SQL guru Lukas Eder looks at the execution...
AI-Powered Automatic PostgreSQL & MySQL Tuning | OtterTune
Auto Optimize Your RDS or Aurora Postgres Databases With AI — Need help optimizing Postgres knobs,...
pgagroal-cli gains JSON output
pgagroal-cli Gains JSON Output Support — pgagroal is a high performance connection pool for Postgres and...
Pavel Stehule's blog: new extension pgmeminfo
pgmeminfo: A New Extension to Investigate Memory Usage — Pavel shows off his new extension which...
(plausible) random geography generation with postgis: fluviation
(Plausible) Random Geography Generation with PostGIS: Fluviation — Geospatial stuff tends to go over my head,...
Connecting to Postgres With psql and .pg_service.conf
Connecting to Postgres with psql and .pg_service.conf — Forgot how to connect to your Postgres services?...
pg_analytics: Transforming Postgres into a Fast OLAP Database - ParadeDB
pg_analytics: Transforming Postgres into a Fast OLAP Database — Some interesting work from the folks over...
PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!
PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released — All supported versions get updates to fix...
What’s new in the Postgres 16 query planner / optimizer
What’s New in the Postgres 16 Query Planner / Optimizer — Query planner improvements rarely make...
GitHub - directus/directus: The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
Directus 10.9: Wrap an SQL Database with a Real-Time GraphQL and REST API — A Node.js-based system...