» Tag
postgresql
6 postsPostgreSQL JSONB vs MongoDB BSON: The Real Architectural Tradeoffs
BSON and JSONB reveal deep architectural differences between MongoDB and PostgreSQL, shaping indexing, update cost, and read performance trade-offs.
postgresqlmongodbjsonbbsonPostgreSQL Benchmark: AWS RDS vs Self-Hosted Hetzner (2026)
In a 2026 2 vCPU/4GB PostgreSQL 16 benchmark, Hostim led on writes, Hetzner won reads on raw CPU, and RDS trailed once hidden costs are counted.
postgresqlbenchmarkaws-rdshetznerPostgreSQL VACUUM's Page-Level Byte-by-Byte Inspection
PostgreSQL VACUUM's three-stage operational mechanism was analyzed at the page level using pageinspect, pg_visibility, and pg_freespacemap. The difference between LP_DEAD and LP_UNUSED becomes clearer.
postgresqlvacuumdatabase-internalsindex-bloatMicrosoft'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.
nosqlpostgresqlmongodbazurepg_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.
postgresqlclickhouseobservabilitydatabasePostgreSQL 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.
postgresqlsqlgodatabase-performance