» Tag
postgresql
65 postsThe Challenge of Adding a Column in the Middle of a PostgreSQL Table
Explore the complexities of adding columns in PostgreSQL and its data storage structure.
Noisia: Harmful Workload Generator for PostgreSQL
Noisia is designed for PostgreSQL, generating harmful workload scenarios for testing purposes.
Multigres Brings Listen/Notify to Pooled Postgres Connections
Multigres uses a shared listener connection and a two-level fan-out to make Postgres listen/notify scale cleanly across pooled connections.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comMicrosoft's DocumentDB Reimagines NoSQL on PostgreSQL
Microsoft open-sourced its vCore Cosmos DB engine as DocumentDB, a PostgreSQL-based NoSQL layer with MongoDB-compatible APIs, BSON support, and ambitions to become a NoSQL standard.
pg_stat_ch Streams PostgreSQL Query Telemetry into ClickHouse
pg_stat_ch is an open-source PostgreSQL extension that streams raw per-query telemetry to ClickHouse, offloading analytics from the database engine.
PostgreSQL Batch UPSERT with CTE: From 90 Seconds to 5
An email sync process with audit history was rewritten from separate queries into a single PostgreSQL CTE, cutting 100k-row processing time from 90 seconds to 5.
The Linux Kernel from a PostgreSQL Perspective
Andres Freund discussed the interaction between PostgreSQL and the Linux kernel.
PostgreSQL Query Plans: Performance Analysis Without Production Data
Understanding PostgreSQL query plans is critical for identifying discrepancies between test and production data. New methods can enhance performance.
PostgreSQL to Remove Property Graph Feature from v19 Due to Design Flaws
PostgreSQL is removing the property graph feature from v19 due to design flaws. Developers found systemic issues affecting stability and consistency.
New Features for Regular Expressions in PostgreSQL: pg_tre and pg_re2
Discover the new pg_tre and pg_re2 extensions in PostgreSQL for improved regular expression handling and performance.