postgres
50 stories and discussions about postgres, aggregated from every source we track.
TIN is a fast, full-featured, full-text search index for Postgres
Paste SQL, parse it locally, and catch Postgres migration lock and rewrite risks before deploy.
Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.
Release blog post for Citus 11, which is now fully open source and includes the non-blocking shard rebalancer. Citus 11 also includes automatic schema and metadata syncing across nodes, enabling you to query from any…
Why Postgres connection poolers still choke on client-side TCP bottlenecks, how QUIC stream multiplexing solves the 30ms latency wall, and real benchmark numbers.
One app, two identical Postgres 17 databases, same region. Local was 4 to 7 times faster on reads because of network latency paid per query. Managed capped at 25 connections with 11 already used, and failed outright past 20 clients until I added the pooler.
We wrote six ordinary Postgres migrations: a new column, a unique index, a reporting index, a wider...
Start in the pgEdge cloud. Deploy in our cloud, your cloud, or on-premises, including air-gapped environments.
Profiling and optimizing the Kafgres Postgres extension to achieve 700 MB/s write throughput and 600k evt/s on a single machine.
A free embed that turns the SQL in your blog posts into real Postgres queries readers can edit and run without leaving the page.
How ClickHouse’s Postgres extensions handle the memory safety challenges of combining C and C++, from clean language boundaries to isolated helper processes.
Postgres change data capture for .NET: stream row changes through typed transforms into Meilisearch, Elasticsearch, OpenSearch, Kafka, pgvector or any HTTP endpoint.
Embedding a performant singleton Kafka broker into Postgres.
Embedding a performant singleton Kafka broker into Postgres.
How a full-text search engine works, and how it works in Postgres
Rails Validations vs Postgres Check Constraints
Suggest the indexing strategy for your database . Contribute to abhiraj-ku/iCli development by creating an account on GitHub.
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.
An extension for PostgreSQL that allows embedded Haskell code. - ed-o-saurus/PLHaskell
How an inefficient Row-Level Security policy drove Postgres CPU to 80%; and why EXPLAIN failed to reveal it.
Paste your CREATE TABLE statements and generate referentially intact Postgres data. No database, no connection string, no config. Weavori's DDL paste mode runs from a schema file.
Relationship based access control for Postgres. Contribute to paulharter/letter development by creating an account on GitHub.
What's New with Monitoring in PostgreSQL 19
Your app, its database and its sign-in on one dedicated machine, run for you: tested backups, TLS, API, MCP. From $15 a month, nothing metered.
Worry-free Postgres for SaaS. Built to scale out. So you can focus on your app—not your database.
Scan a Postgres credential's effective privileges. Contribute to vaultkit-inc/agent-db-scan development by creating an account on GitHub.
ADD CONSTRAINT UNIQUE runs in milliseconds and locks nothing that matters, then aborts on a duplicate email. Fixtures hide it and so does uniform random data. Here is the data shape that exposes it.
Read-only Postgres MCP server: a drop-in replacement for the archived server-postgres, with schema context for correct answers. - contextflo/postgres-mcp
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.
Follow a SQL query through the router, across four Postgres shards, and back.
Your CI database picks different plans than production because its statistics differ. Inject production stats with PostgreSQL 18, or generate rows that carry the distribution. Here is how to tell which one you need.
How a full-text search engine works, and how it works in Postgres
A long time ago I ran a write-heavy system on a hub and a handful of workers. Each worker took a share of the application traffic and wrote events locally. The …
WalShadow replicates PostgreSQL to ClickHouse by decoding the physical WAL stream itself, not logical decoding.
It’s been a month since I published the first part of this research, and interest from the Postgres community has been higher than I expected. Most vendors I contacted were shy to respond, so the Databricks…
Execute chDB queries in Postgres. Contribute to ClickHouse/pg_chdb development by creating an account on GitHub.
Postgres 19 is delayed due to late-stage feature reversions and AI-driven bug detection. Learn what features were pulled and what to expect next.
Exception-only error monitoring. Sentry SDK compatible. 2-container self-host. - epure-sh/epure
Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
The SQL parser powering pgdog.dev. Contribute to pgdogdev/pg_raw_parse development by creating an account on GitHub.
A fencing token is not a paragraph. It is a counter that must rise on a clock, die on a deadline, and...
<p>The ORM we use didn't support transactions so I wrote this! Hope it's useful.</p>
Testing semantic search, filtered queries, and multi-table joins in AlloyDB to measure the true cost...