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