Published on: 2025-04-26 10:33:10
Hacking the Postgres wire protocol Apr 14th, 2025 Lev Kokotov PgDog is a network proxy and it can see every byte sent between Postgres and the clients. It understands SQL and can infer where queries should go, without requiring changes to application code. In this article, we discuss how we handle the Postgres wire protocol and manipulate it to serve queries to multiple databases at the same time. Protocol basics Postgres has two ways to send queries over the network: Simple protocol Ext
Keywords: data message pgdog postgres query
Find related items on AmazonPublished on: 2025-04-27 11:33:10
Hacking the Postgres wire protocol Apr 14th, 2025 Lev Kokotov PgDog is a network proxy and it can see every byte sent between Postgres and the clients. It understands SQL and can infer where queries should go, without requiring changes to application code. In this article, we discuss how we handle the Postgres wire protocol and manipulate it to serve queries to multiple databases at the same time. Protocol basics Postgres has two ways to send queries over the network: Simple protocol Ext
Keywords: data messages pgdog postgres query
Find related items on AmazonPublished on: 2025-05-07 03:00:15
You might have come across discussions or blog posts suggesting that PostgreSQL's built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions. A notable recent example comes from Neon's blog post, "Performance Benchmark: pg_search on Neon" (link). In their benchmark, Neon compared query performance on their database platform with their pg_search extension (based on Rust's Tantivy library via pgrx ) against the Postgres built-in fullt
Keywords: fts index performance postgresql standard
Find related items on AmazonPublished on: 2025-05-22 21:14:36
PostgreSQL Model Context Protocol (PG-MCP) Server A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents. Overview PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture. This implementation builds upon and extends the reference Postgres MCP implementat
Keywords: connection database mcp postgresql server
Find related items on AmazonPublished on: 2025-05-22 18:13:43
Postgres Language Server A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling. Docs: pgtools.dev Install: instructions Overview This project provides a toolchain for Postgres development, built on Postgres' own parser libpg_query to ensure 100% syntax compatibility. It is built on a Server-Client architecture with a transport-agnostic design. This means all features can be accessed not only
Keywords: error features language postgres server
Find related items on AmazonPublished on: 2025-05-25 02:20:44
Postgres Extension Tutorial Welcome to the Postgres Extension Tutorial. This comprehensive tutorial is designed to provide a step-by-step guide to PostgreSQL extension development. Whether you're new to PostgreSQL or extension development, this tutorial assumes only a basic knowledge of Postgres and the target programming language. It covers various aspects of creating, managing, and distributing extensions for PostgreSQL. After completing this tutorial, you'll have a strong foundation in Post
Keywords: development extension postgres postgresql tutorial
Find related items on AmazonPublished on: 2025-06-15 00:07:11
You can make Postgres scale Mar 13th, 2025 Lev Kokotov Postgres scales. No other two words that I’ve ever heard of, produced more controversy. At least in the circles I hang out in, in the company basement where infrastructure elves make the Rails app go brrr. A lot of people believe, against all odds, and marketing campaigns by Big NoSQL, that technology you know is better than the devil you just heard pitched at the Engineering Leadership meeting. To be completely fair, I get where they ar
Keywords: just make postgres time write
Find related items on AmazonPublished on: 2025-06-15 10:07:11
You can make Postgres scale Mar 13th, 2025 Lev Kokotov Postgres scales. No other two words that I’ve ever heard of, produced more controversy. At least in the circles I hang out in, in the company basement where infrastructure elves make the Rails app go brrr. A lot of people believe, against all odds, and marketing campaigns by Big NoSQL, that technology you know is better than the devil you just heard pitched at the Engineering Leadership meeting. To be completely fair, I get where they ar
Keywords: just make postgres time write
Find related items on AmazonPublished on: 2025-06-23 12:59:04
TLDR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases. What’s more, all compute is within Postgres, and all tables are managed directly by PostgreSQL—it’s not a simple wrapper. This is the story of pg_mooncake. What Is ClickBench? ClickBench is the definitive benchmark for real-time analytics databases, originally designed to showcase the performance of ClickHouse. It evaluates databases on
Keywords: analytics databases execution postgres postgresql
Find related items on AmazonPublished on: 2025-07-07 12:14:22
What’s New The Internals of PostgreSQL PostgreSQL is a well-designed, open-source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works cooperatively with each other. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity make it difficult. The main purposes of th
Keywords: author content document postgresql use
Find related items on AmazonPublished on: 2025-07-07 23:10:23
We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 scoring and ranking right into PostgreSQL, making your searches smarter and faster. What’s New? BM25 Scoring & Ranking : Get more precise and relevant search results with BM25, helping you find what matters most. Optimized Indexing : Thanks to the Blo
Keywords: bm25 documents elasticsearch postgresql text
Find related items on AmazonPublished on: 2025-07-15 11:47:06
Check out the discussion of this post on Hacker News. We have news! EdgeDB is rebranding as Gel, more on that below. Let's talk about something else first. Something fascinating has been happening recently. PostgreSQL seems to be quietly eating the database world. It's not just topping the charts, its adoption momentum is accelerating. What's going on? The answer is right there in the PostgreSQL.org's tagline: The World's Most Advanced Open Source Relational Database It's not just an empty
Keywords: database gel just postgres postgresql
Find related items on AmazonPublished on: 2025-07-15 11:47:06
We have news! EdgeDB is rebranding as Gel, more on that below. Let's talk about something else first. Something fascinating has been happening recently. PostgreSQL seems to be quietly eating the database world. It's not just topping the charts, its adoption momentum is accelerating. What's going on? The answer is right there in the PostgreSQL.org's tagline: The World's Most Advanced Open Source Relational Database It's not just an empty marketing boast. It's meaningful. Let's unpack, startin
Keywords: database gel just postgres postgresql
Find related items on AmazonGo K’awiil is a project by nerdhub.co that curates technology news from a variety of trusted sources. We built this site because, although news aggregation is incredibly useful, many platforms are cluttered with intrusive ads and heavy JavaScript that can make mobile browsing a hassle. By hand-selecting our favorite tech news outlets, we’ve created a cleaner, more mobile-friendly experience.
Your privacy is important to us. Go K’awiil does not use analytics tools such as Facebook Pixel or Google Analytics. The only tracking occurs through affiliate links to amazon.com, which are tagged with our Amazon affiliate code, helping us earn a small commission.
We are not currently offering ad space. However, if you’re interested in advertising with us, please get in touch at [email protected] and we’ll be happy to review your submission.