OpenSource-DB.com

Celebrate the Grand Finale of #PG18Hacktober !! We're excited to announce the culmination of our 31-day journey exploring PostgreSQL 18's innovative features! shorturl.at/81nmP 31 days. 31 blogs. #PG18Hacktober. #PG18 #OpenSourceDB

Its Day30 of PG18Hacktober !! PG18 brings significant improvements to its system catalogs and statistics views, expanding monitoring capabilities and providing DBAs & Devs with more granular insights into operations. shorturl.at/PHq5U #PG18Hacktober #PG18 #OpenSourceDB

Welcome to the final third of #PG18Hacktober Day29 is live: pg_unicode_fast is a new built-in collation introduced in PostgreSQL 18, available exclusively for UTF-8 encoded databases. opensource-db.com/pg18-hacktober… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

Welcome to the #PG18Hacktober Day28 is live: In PostgreSQL 18, the LIKE operator becomes more powerful and more compliant with the SQL standard, it now supports use with nondeterministic collations. opensource-db.com/pg18-hacktober… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

Welcome to the #PG18Hacktober Among the many new features, one quiet and small feature is making its debut, promising to enable developers and DBAs approach case-insensitive string matching: the casefold() function. opensource-db.com/pg18-hacktober… 31 days.31 blogs. #PG18 #OpenSourceDB

Meet pg_overexplain, a brand-new #PostgreSQL18 extension that lets you peek behind the curtain to see what the planner actually executes — not just what your SQL looks like. Read more : opensource-db.com/pg18-hacktober… #OpenSourceDB #PG18Hacktober

Want to peek into logical replication without breaking it? PostgreSQL 18’s new pg_logicalinspect extension lets you inspect slots, WAL, and snapshots, all from SQL! Day 25 of #PG18Hacktober opensource-db.com/pg18-hacktober… #PG18Hacktober #PostgreSQL #PG18 #LogicalReplication #OpenSource

Welcome to the Day24 of #PG18Hacktober!! Today, let's explore how #PostgreSQL18 elevates the psql experience with the ability to \parse, \bind_named, and \close the prepared statements right at the CLI. Read more: opensource-db.com/pg18-hacktober… #OpenSourceDB

#PostgreSQL18 just made psql a lot more powerful! With the introduction of pipeline query support, we can now send multiple queries together. No C code, no drivers — just pure psql magic with commands like \startpipeline & \syncpipeline. opensource-db.com/pg18-hacktober… #PG18Hacktober

In today’s #PG18Hacktober spotlight — PostgreSQL18 makes postgres_fdw smarter and safer with SCRAM pass-through authentication. No more passwords in mappings, no more manual secret management — just secure, seamless cross-server connections. opensource-db.com/pg18-hacktober… #OpenSourceDB

PostgreSQL 18 adds schema magic to FDWs with: CREATE FOREIGN TABLE ... LIKE In Part 2 of our #PG18Hacktober series, we unpack: INCLUDING COMMENTSSTORAGE / COMPRESSIONGotchas & best practices opensource-db.com/pg18-hacktober… #PG18Hacktober #PostgreSQL

New in #PG18Hactober: CREATE FOREIGN TABLE ... LIKE Clone your schema with ease — constraints, defaults & all Part 1 of our #PG18Hacktober blog explores why this tiny feature packs a punch. opensource-db.com/pg18-hacktober… #PostgreSQL #PG18Hactober #OpenSourceDB

Automating #PostgreSQL18 installation and replication with #Ansible — no more manual setup or downtime. In Day19 of #PG18Hacktober, let's deploy, configure, and scale your clusters seamlessly across RHEL with one playbook. Read here : opensource-db.com/pg18-hacktober… #OpenSourceDB

Virtual Generated Columns are here in #PostgreSQL18! In Day 18 of #PG18Hacktober, we explore how virtual columns make dynamic fields clean, fast, and space-efficient. Read it opensource-db.com/pg18-hacktober… #PG18Hacktober

Welcome to the 2nd blog of Asynchronous I/O in #PG18Hacktober series. In Day 17 ,let's break down why — from CPU-bound checksums to memcpy bottlenecks — and share tuning tips for io_method and io_workers. opensource-db.com/pg18-hacktober… #OpenSourceDB

Halfway through #PG18Hacktober! After years of anticipation, PostgreSQL18 finally delivers one of its most transformative features: Asynchronous I/O (AIO). Let's deep dive into PostgreSQL internal and the performance revolution behind PG18. opensource-db.com/pg18-hacktober… #OpenSource

Welcome to the #PG18Hacktober Day15 is live: PostgreSQL 18 introduces powerful temporal constraints that help manage and validate time-based data directly within the database schema. opensource-db.com/pg18-hacktober… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

Welcome to the #PG18Hacktober Day14 is live: PostgreSQL 18 introduced significant enhancements in logical replication, including better handling and tracking of write conflicts. opensource-db.com/pg18-hacktober… 31 days.31 blogs.#PG18Hacktober. #PG18 #OpenSourceDB

Welcome to the Day13 of #PG18Hacktober Let's learn how to capture the modified rows using RETURNING Clause. opensource-db.com/pg18-hacktober… #PG18 #SQL #OpenSource #Databases #ReturningClause #DML

In Part 2 of our Logical replication section series is out! Day12 of #PG18Hacktober : Learn how to replicate only the columns you need using stored generated columns + column lists. More control, less overhead opensource-db.com/pg18-hacktober… #LogicalReplication #OpenSource #Databases