OpenSource-DB.com

Software company

[OpenSource-DB.com @opensource_db]

Celebrate the Grand Finale of #PG18Hacktober !!

We're excited to announce the culmination of our 31-day journey exploring PostgreSQL 18's innovative features!

https://t.co/8F2GFLFu7O

31 days. 31 blogs. #PG18Hacktober.
#PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

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.
https://t.co/2y1vkA7FzE
#PG18Hacktober #PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

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.

https://t.co/yR4VWdhhv8

31 days.31 blogs.#PG18Hacktober.
#PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

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.

https://t.co/DOQD8Uvc7r

31 days.31 blogs.#PG18Hacktober.
#PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

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.
https://t.co/7PSNEdsDXJ

31 days.31 blogs.
#PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

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 : https://t.co/1ApB7Ie1sS

#OpenSourceDB #PG18Hacktober

[OpenSource-DB.com @opensource_db]

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
https://t.co/hnZSPRBo2v

#PG18Hacktober #PostgreSQL #PG18 #LogicalReplication #OpenSource

[OpenSource-DB.com @opensource_db]

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: https://t.co/kt8cNMBki0

#OpenSourceDB

[OpenSource-DB.com @opensource_db]

#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.

https://t.co/n64qoI9PtA

#PG18Hacktober

[OpenSource-DB.com @opensource_db]

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.
https://t.co/ELVSzt31DF
#OpenSourceDB

[OpenSource-DB.com @opensource_db]

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

https://t.co/zn4aKoDMAa

#PG18Hacktober #PostgreSQL

[OpenSource-DB.com @opensource_db]

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.

https://t.co/1gHOKO9UQd

#PostgreSQL #PG18Hactober #OpenSourceDB

[OpenSource-DB.com @opensource_db]

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 : https://t.co/KgStARfRFw

#OpenSourceDB

[OpenSource-DB.com @opensource_db]

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 https://t.co/XSrMJ2fOzP

#PG18Hacktober

[OpenSource-DB.com @opensource_db]

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.

https://t.co/Yt5oXk7Ncs

#OpenSourceDB

[OpenSource-DB.com @opensource_db]

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.

https://t.co/rD7b7CP5vv

#OpenSource

[OpenSource-DB.com @opensource_db]

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.

https://t.co/COZC9FqN66

31 days.31 blogs.#PG18Hacktober.
#PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

Welcome to the #PG18Hacktober

Day14 is live:
PostgreSQL 18 introduced significant enhancements in logical replication, including better handling and tracking of write conflicts.

https://t.co/D5lvUH9V8F

31 days.31 blogs.#PG18Hacktober.
#PG18 #OpenSourceDB

[OpenSource-DB.com @opensource_db]

Welcome to the Day13 of #PG18Hacktober

Let's learn how to capture the modified rows using RETURNING Clause.

https://t.co/eDs3SIAtWa

#PG18 #SQL #OpenSource #Databases #ReturningClause #DML

[OpenSource-DB.com @opensource_db]

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

https://t.co/iNFK3ViiWv

#LogicalReplication #OpenSource #Databases