Published on: 2025-06-03 08:16:15
Join our daily and weekly newsletters for the latest updates and exclusive content on industry-leading AI coverage. Learn More The open-source PostgreSQL (sometimes also referred to as Postgres) is apparently a very hot commodity for big enterprise data platform vendors. Snowflake is acquiring privately-held PostgreSQL provider Crunchy Data, in a deal that is reportedly valued at $250 million. The acquisition comes barely two weeks after Snowflake’s rival Databricks acquired serverless Postgre
Keywords: crunchy data enterprise postgresql snowflake
Find related items on AmazonPublished on: 2025-06-15 16:55:49
PgDog is a transaction pooler and logical replication manager that can shard PostgreSQL. Written in Rust, PgDog is fast, secure and can manage hundreds of databases and hundreds of thousands of connections. Documentation 📘 PgDog documentation can be found here. Any questions? Join our Discord. Quick start Kubernetes Helm chart is here. To install it, run: git clone https://github.com/pgdogdev/helm && \ cd helm && \ helm install -f values.yaml pgdog ./ Docker You can try PgDog quickly usi
Keywords: database databases pgdog postgresql queries
Find related items on AmazonPublished on: 2025-06-17 15:12:44
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL database management and development workflows. With this extension, you can now manage database objects, draft queries with intelligent assistance from context-aware IntelliSense and our ‘@pgsql’ GitHub Copilot agent—all without ever leaving your favorite code editor. Addressing Developer Challenges Many of you face hurdles in managing time effec
Keywords: code context copilot database postgresql
Find related items on AmazonPublished on: 2025-06-18 01:12:44
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL database management and development workflows. With this extension, you can now manage database objects, draft queries with intelligent assistance from context-aware IntelliSense and our ‘@pgsql’ GitHub Copilot agent—all without ever leaving your favorite code editor. Addressing Developer Challenges Many of you face hurdles in managing time effec
Keywords: code context copilot database postgresql
Find related items on AmazonPublished on: 2025-06-18 20:54:38
At the PGConf.dev 2025 Global Developer Conference, Bohan Zhang from OpenAI shared OpenAI’s best practices with PostgreSQL, offering a glimpse into the database usage of one of the most prominent unicorn companies. At OpenAI, we utilize an unsharded architecture with one writer and multiple readers, demonstrating that PostgreSQL can scale gracefully under massive read loads. — PGConf.dev 2025, Bohan Zhang from OpenAI Bohan Zhang is a member of OpenAI’s Infrastructure team. He studied under Pr
Keywords: openai postgresql read replicas write
Find related items on AmazonPublished on: 2025-06-27 20:06:14
Here at Xata, we’ve been quietly busy (re)building a new PostgreSQL platform from scratch. We've incorporated everything we learned from operating a Postgres data platform for over four years, combined with feedback from our customers and our analysis of the gaps in the current market. The result is an entirely new Postgres service that: Has instant Copy-on-Write branches with data. Includes data anonymization so that developer branches don’t accidentally contain PII. Is cloud-agnostic, inst
Keywords: data platform postgres storage xata
Find related items on AmazonPublished on: 2025-06-29 03:24:23
Blog The fastest Postgres inserts The fastest Postgres inserts Since you’re here, you might be interested in checking out Hatchet — the platform for running background tasks, data pipelines and AI agents at scale. Alexander Belanger Published on May 15, 2025 At Hatchet, we spent the past half year running hundreds of benchmarks against different Postgres configurations. We set out with a simple question: at what scale does Postgres break? For us, the question is existential — we use Postgre
Keywords: connection connections latency postgres throughput
Find related items on AmazonPublished on: 2025-06-30 13:54:06
Join our daily and weekly newsletters for the latest updates and exclusive content on industry-leading AI coverage. Learn More The importance of databases to modern enterprise AI operations cannot be overstated. Data helps to train and ground AI, and multiple research reports show that without proper data, AI efforts tend to fail. With trends like vibe coding and agentic AI, it’s also increasingly important to have database technology that can be spun up as needed in a serverless approach to m
Keywords: ai data database postgresql serverless
Find related items on AmazonPublished on: 2025-07-01 23:10:00
Today, we are excited to announce that we have agreed to acquire Neon, a developer-first, serverless Postgres company. Neon’s co-founders are among the very few people in the world who could re-architect Postgres with true separation of storage and compute, built for modern developers and AI systems. Their world-class team of Postgres hackers and database veterans will join Databricks to deliver serverless Postgres at production scale to developers in an AI-native world. A developer-first missi
Keywords: ai database developers neon postgres
Find related items on AmazonPublished on: 2025-07-02 20:39:45
Migrating to Postgres Sean Callahan Follow 8 min read · 1 day ago 1 day ago -- Listen Share Since early 2022, Motion was on CockroachDB. Cockroach has many qualities going for it: effortless horizontal scaling, especially when dealing with multi-region set ups, extremely high availability, and a SQL-compatible interface. Early on, there were concerns about the eventuality of a multi-region setup (mandated by GDPR), and how exactly a traditional set up on Postgres would scale. However, as Motio
Keywords: cockroach head migration postgres query
Find related items on AmazonPublished on: 2025-07-04 11:10:00
Today, we are excited to announce that we have agreed to acquire Neon, a developer-first, serverless Postgres company. Neon’s co-founders are among the very few people in the world who could re-architect Postgres with true separation of storage and compute, built for modern developers and AI systems. Their world-class team of Postgres hackers and database veterans will join Databricks to deliver serverless Postgres at production scale to developers in an AI-native world. A developer-first missi
Keywords: ai database developers neon postgres
Find related items on AmazonPublished on: 2025-07-15 08:57:03
With the Postgres 18 Beta 1 release this week a multi-year effort, and significant architectural shift in Postgres is taking shape: Asynchronous I/O (AIO). These capabilities are still under active development, but they represent a fundamental change in how Postgres handles I/O, offering the potential for significant performance gains, particularly in cloud environments where latency is often the bottleneck. While some features may still be adjusted or dropped during the beta period before the
Keywords: 18 asynchronous postgres read test
Find related items on AmazonPublished on: 2025-07-27 13:30:11
1 Background PostgreSQL is a popular open source general-purpose SQL database. It uses multiversion concurrency control (MVCC) to provide three levels of transaction isolation. PostgreSQL’s “Read Uncommitted” and “Read Committed” are both Read Committed. The “Repeatable Read” level actually provides Snapshot Isolation, not Repeatable Read. “Serializable” provides Serializability. Amazon RDS for PostgreSQL is an AWS service which provides managed PostgreSQL clusters. RDS automates provisioning,
Keywords: isolation postgresql rds read transactions
Find related items on AmazonPublished on: 2025-07-27 23:30:11
1 Background PostgreSQL is a popular open source general-purpose SQL database. It uses multiversion concurrency control (MVCC) to provide three levels of transaction isolation. PostgreSQL’s “Read Uncommitted” and “Read Committed” are both Read Committed. The “Repeatable Read” level actually provides Snapshot Isolation, not Repeatable Read. “Serializable” provides Serializability. Amazon RDS for PostgreSQL is an AWS service which provides managed PostgreSQL clusters. RDS automates provisioning,
Keywords: isolation postgresql rds read transactions
Find related items on AmazonPublished on: 2025-08-19 20: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-08-20 21: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-08-30 13: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-09-15 07: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-09-15 04: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-09-17 12: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-10-08 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-10-08 20: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-10-16 22: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-10-30 22: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-10-31 09: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-11-09 00: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-11-09 00: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.