Postgres
We track 48 posts about Postgres from 17 engineering blogs. Most active: Clickhouse, Timescale, SeveralNines. Latest post: Oct 9, 2026.
Companies writing about Postgres
Recent posts
Measuring How Fast Your IIoT Queries Are Degrading (opens on the source site)
Stop waiting for the dashboard to get slow. Record latency against row count, fit the curve, and get a date when your query breaches its target.
How we migrated Clera’s 500 GB production database to ClickHouse Managed Postgres overnight (opens on the source site)
Clera migrated its 500 GB production database and 500+ tables to ClickHouse Managed Postgres overnight, cutting CPU usage from 100% to 10–20%.
🗽 Postgres Summit US 2026 retrospective (opens on the source site)
Highlights from Postgres Summit US 2026 in New York City, where ClickHouse sponsored the community and demonstrated its growing Postgres integrations.
What is direct I/O, and why does ClickHouse Managed Postgres use it for backups? (opens on the source site)
ClickHouse Managed Postgres uses direct I/O and stripe-sized reads to keep backups fast while protecting the page cache and query latency.
Amazon Aurora PostgreSQL now supports direct querying of Apache Iceberg and Parquet data in your data lake (opens on the source site)
AWS ·
Amazon Aurora PostgreSQL now lets you directly query Apache Iceberg and Parquet data stored in your data lake alongside live operational data—no ETL pipelines required. Powered by DuckDB embedded within Aurora, this capability enables single queries that join transactional and historical data using familiar PostgreSQL syntax. It supports AWS Glue Data Catalog, S3, and S3 Tables, with optimizations like predicate pushdown and caching for efficient performance.
Memory safety for Postgres extensions in C/C++ (opens on the source site)
How ClickHouse’s Postgres extensions handle the memory safety challenges of combining C and C++, from clean language boundaries to isolated helper processes.
Can your Postgres survive a bad query? (opens on the source site)
How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
JPA Inspired ORM from SQLite to PostgreSQL (opens on the source site)
Use managed ORM sessions, relationships, lazy loading, JPQL queries, and optimistic locking with shared Java entities on the client and backend.
Sizing Your IIoT Table Before You Deploy (opens on the source site)
A 20-byte sensor reading costs 95.6 on disk. Measure bytes per row, project 631 billion rows, and test your ingest ceiling before the schema review.
How to Build a PostgreSQL CI/CD Pipeline with GitOps and Kubernetes (opens on the source site)
Application teams have been living in Git-driven, immutable-deployment land for years. Databases lagged for good reason: That gap has closed considerably now that Kubernetes operators understand PostgreSQL well enough to manage replication, failover, and storage declaratively. What’s still missing in a lot of pipelines is the operational layer that sits on top of “it deployed”, […] The post How to Build a PostgreSQL CI/CD Pipeline with GitOps and Kubernetes appeared first on Severalnines.
Postgres on NVMe: performance and the convergence of transactions and analytics (opens on the source site)
See how local NVMe transforms Postgres transaction performance—and why ClickHouse remains essential for fast analytics as workloads scale.
Diagnosing PostgreSQL Index Bloat, Write Amplification, and Buffer Cache Hit Ratios (opens on the source site)
Diagnose PostgreSQL index bloat, write amplification, and buffer cache hit ratios with system-catalog SQL queries, then reindex with zero downtime. Continue reading Diagnosing PostgreSQL Index Bloat, Write Amplification, and Buffer Cache Hit Ratios on SitePoint.
Knowing When Your Composite Index Earns Its Write Cost (opens on the source site)
Composite indexes charge every insert and pay back only some queries. Four steps to price both sides and audit the indexes you already run.
Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026 (opens on the source site)
Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.
How to Set Up n8n Workflow Automation with Docker and PostgreSQL on Ubuntu 26.04 (opens on the source site)
In this blog post, we will show you how to set up n8n workflow automation with Docker and PostgreSQL on ... Read More The post How to Set Up n8n Workflow Automation with Docker and PostgreSQL on Ubuntu 26.04 appeared first on RoseHosting.
PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum (opens on the source site)
Laravel ·
Vacuum checks PostgreSQL in Laravel apps for bloat, wraparound, and unused indexes, and flags unindexed foreign keys in migrations during CI. The post PostgreSQL Monitoring and Schema Linting for Laravel with Vacuum appeared first on Laravel News. Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.
The Real Cost of a Single Insert in Postgres (opens on the source site)
PostgreSQL write amplification explained: why indexes multiply WAL volume, how to measure it on your tables, and four ways to reduce it without schema changes.
Three principles for building a vector platform at Thumbtack (opens on the source site)
Reusing what we already had, treating embeddings as data, and lowering the next team’s costToday, an ML engineer at Thumbtack can stand up production vector search without negotiating database access, building a custom ETL, or writing a query service. The team brings their choice of embedding model, the data, and the query; the platform handles what connects them. It took several iterations to get to this point. In this post we’ll walk through how we got there and the three principles that shaped what we built.A vector database stores high-dimensional numeric arrays (embeddings) and serves…
Announcing ClickHouse Managed Postgres on Google Cloud (opens on the source site)
ClickHouse Managed Postgres is expanding to Google Cloud, bringing NVMe-backed storage, native CDC into ClickHouse, and a unified query layer via pg_clickhouse to GCP private preview customers.
From Neon Postgres to ClickHouse Managed Postgres (opens on the source site)
Three teams share why they migrated production Postgres workloads from Neon to ClickHouse Managed Postgres and how ClickPipes helped them cut over in hours.
New system views in PostgreSQL 19 (opens on the source site)
PostgreSQL 19 adds four system views that make lock contention, recovery state, autovacuum priorities, and dynamic shared memory allocations easier to inspect.
Why a 40-Year-Old Database Is Still Winning in the AI Era (opens on the source site)
Why Postgres wins in the AI era: 40 years of reliability, extensibility, and an open ecosystem. Agents need trusted foundations, not fragile architectures.
How to Install Nextcloud on Ubuntu 26.04 with NGINX, PostgreSQL/MariaDB, and Redis (Complete 2026 Guide) (opens on the source site)
Nextcloud is the most popular open-source self-hosted file sync and sharing application. It is an alternative to other file-sharing applications ... Read More The post How to Install Nextcloud on Ubuntu 26.04 with NGINX, PostgreSQL/MariaDB, and Redis (Complete 2026 Guide) appeared first on RoseHosting.
Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows (opens on the source site)
Cardinality is a consequence of how many dimensions you index your readings by. Here is where the curve bends, measured, and what you can do about it without leaving Postgres. Someone adds a firmware_ver column to the sensor table. It is one line of DDL, and it clears review in a minute. Two weeks later, the ingest job is missing its window, a dashboard query that used to return in milliseconds takes seconds, and the on-call engineer is digging through EXPLAIN output to work out when the planne
A new getting started experience for ClickHouse Managed Postgres (opens on the source site)
See how a four-step onboarding flow helps users move from provisioning ClickHouse Managed Postgres to querying operational data and running real-time analytics with ClickHouse.
A universal interface: How QuintoAndar made ClickHouse plug-and-play with managed Postgres (opens on the source site)
QuintoAndar unified ~900 million monthly events in ClickHouse Cloud and used ClickHouse Managed Postgres to make that data accessible to Hightouch and any Postgres-compatible tool.
Postgres + ClickHouse Architectural Patterns (opens on the source site)
The role of databases has shifted significantly as modern applications must deliver real-time analytics, dashboards, and machine learning alongside low-latency transaction processing. Handling these diverse demands with a single relational database has become unsustainable under growing data volumes. Consequently, organizations are adopting specialized database architectures where multiple engines work together based on their strengths, allowing […] The post Postgres + ClickHouse Architectural Patterns appeared first on Severalnines.
Read your writes: WAIT FOR in PostgreSQL 19 (opens on the source site)
PostgreSQL 19's new `WAIT FOR` command enables read-your-writes consistency on asynchronous replicas by letting individual reads wait for a specific WAL position.
Inserting State Transitions in Postgres (opens on the source site)
An append-only status model gives you full history, but concurrent transitions can produce contradictory records. Here's how to prevent that.
What else runs on your Postgres server, and how do we stop it from taking the database down? (opens on the source site)
ClickHouse Managed Postgres uses runtime budgets, cgroup limits, and disk-full session exemptions to keep supporting services from compromising database availability.
Related topics
This page is generated automatically from the engineering blogs we follow. Every post links to its source, where it was published. See all sources.