Codú
Avatar for PlanetScale Blog

PlanetScale Blog

@planetscale-blog

◷ Joined January 2026planetscale.com
36
Posts
ArticlePlanetScale Blog@planetscale-blog · 1d ago · 7 min

Building PlanetScale with Insights Agent

We've always used PlanetScale to build PlanetScale. So when we built Insights Agent, our own databases were the first place we ran it to see what kind of gains we could get. Insights Agent identifies problematic queries or schema using Query Insights, finds the code responsible for them, and opens a...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · 2d ago · 3 min

PlanetScale ranks #24 in Deloitte's Technology Fast 500

PlanetScale is #24 on the 2026 Deloitte Technology Fast 500, a ranking of the fastest-growing technology companies in North America. Now in its 32nd year, the list ranks companies by revenue growth over a three-year period. To qualify, companies submit their revenue figures along with financial docu...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · 3d ago · 6 min

Introducing Insights Agent

PlanetScale Insights has long shown you exactly how your queries perform in production and recommended fixes using deterministic algorithms. However, fixing what it finds has been mostly up to you and your agents. Today we're introducing Insights Agent. These are agents built right into the PlanetSc...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Nov 11 · 13 min

How we migrate TBs from Heroku without logical replication

Since we launched PlanetScale Postgres, companies have been moving to it from just about every Postgres provider out there, and Heroku Postgres is no exception. Our team has helped many customers leave Heroku, ranging from small databases on the order of hundreds of gigabytes to others with many ter...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Nov 5 · 11 min

Designing a reliable unplanned failover

In Designing a planned switchover for minimum disruption, we discussed how Neki moves Postgres primaryship when all the participants are healthy. Admin, Neki's control plane, knows when the primary is going to step aside. It can inspect the shard, select a target, and prepare the handoff before caus...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Nov 3 · 9 min

The hidden latency inside your database

Network-attached storage is a fine choice and a bad default. Application performance 101 says you want to move your application as close as possible to your database. The shorter that distance across the network, the faster reads and writes move between them. But did you know there is network latenc...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Oct 29 · 8 min

Designing a planned switchover for minimum disruption

A Neki shard consists of one Postgres primary and multiple replicas. The primary accepts writes; the replicas do not. From time to time, we need one of those replicas to take over as the primary. We may be replacing a (Kubernetes) pod, upgrading the kernel, or moving the primary to another cell. Thi...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Oct 27 · 11 min

What was the turning point for Postgres?

Postgres is the most popular database choice among developers. Postgres is the default choice for agents, powering countless applications where those new to app building don't even know what a database is. Every major cloud offers hosted Postgres. But in a time where software development is being tu...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Oct 23 · 10 min

Shard design doesn't start from your tables

Previously, in The lifecycle of a sharded Postgres query, the router had to join customers and orders itself, because each table was sharded by its own ID. The fix was to shard orders by customer_id, hashed and mapped the same way as customers. In Neki, that fix is called a "shard group." Sharding s...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Oct 21 · 6 min

I don't trust ON DELETE CASCADE

Postgres ON DELETE CASCADE is very tempting to use at first. Fully integrity checked, atomic deletion of your data. You don't need to write any application code to clean up related rows, you simply set up your foreign keys, then issue a single DELETE statement, Postgres takes care of the rest. What...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Oct 20 · 4 min

Neki update: $50 Metal, read-only replicas, Azure, and more

Neki, our sharded Postgres, has been in platform preview for about a month. The team continues to work towards the path to production-readiness, and we've added quite a few new features and capabilities since launch. Here's a quick look at what's landed since the preview opened and how you can start...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Jun 11 · 7 min

The only scalable delete in Postgres is DROP TABLE

Counterintuitively, large DELETEs add work to the database. From experience we can plainly claim the following: the most scalable Postgres data-deletion strategies revolve around deleting entire tables. Individual row DELETE is fine at a small scale. However, big batch DELETE operations don't immedi...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · May 14 · 11 min

Egress problems and where to find them

Name something in recent history that got better and cheaper (other than the TVs at the entrance of Costco). I'll wait. Better performance and lower costs rarely come together, but optimizing your queries to reduce egress gives you both. So once you hit scale, or ideally before scale bites you, impr...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · May 7 · 13 min

Problem solving with PlanetScale Insights

There are so many ways your database can disappoint you. It'll make your application perform in ways you don't expect and upset your users. In a sufficiently complex application, finding and eliminating performance problems can be difficult. Fortunately, PlanetScale gives you the tools to isolate th...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · May 5 · 13 min

On benchmarking

Benchmarking is hard.There are many ways to do it wrong and few to do it right. But zooming out from any single system or harness, there are broad principles that should be applied to all benchmarking.Using these correctly makes it difficult to produce biased results. Am I the world's best benchmark...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · May 5 · 3 min

Transparency in benchmarking

Database benchmarks are imperfect.They are also useful. No benchmark can tell you exactly how a database will perform for your application.Workload shape, data size, region placement, storage, configuration, and cost all matter.But fair benchmarks help customers understand tradeoffs, compare options...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Apr 30 · 12 min

RLS sounds great until it isn't

When you leave your house, go to sleep, or go do work in the yard, you lock yourdoor. Maybe you have a gate or fence you lock too. Without these, anyone canwaltz into your house and snoop around. Row Level Security (RLS) can be attractive to developers for numerous reasons,but the foot-guns and gotc...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Apr 21 · 15 min

Approaches to tenancy in Postgres

Multi-tenancy is a term used across various kinds of technical infrastructure, including application hosting, compute, databases, and more. For example, you may purchase cloud services from a provider, but your account is one of many that draws from a common pool of resources. Your account is one "t...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Apr 10 · 19 min

Keeping a Postgres queue healthy

A healthy digestive system is one that efficiently eliminates waste. Fiber is a key part of a healthy diet, not because it is nutritious, but because it keeps everything you consume moving. Databases are not so different. If you want a healthy queue table, you'll need to monitor the systems that are...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Apr 2 · 13 min

Patterns for Postgres Traffic Control

Last week we introducedDatabase Traffic Control™. TrafficControl lets you attach resource budgets to slices of your Postgres traffic,like keeping your checkout flow running while a runaway analytics query getsshed instead. We have already discussed some scenarios where youshould use Traffic Control,...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 31 · 7 min

Graceful degradation in Postgres

Not all traffic is created equal.When a database is overwhelmed, you want the important queries to keep executing, even if that means shedding lower-priority work.This is a much better outcome than the alternative: a total database outage. PlanetScale's Traffic Control makes this feasible at the dat...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 30 · 9 min

High memory usage in Postgres is good, actually

Houseplants often die from over-watering, not neglect. It is easy to project human needs onto them: "If I am thirsty, they must be thirsty too." But many indoor plants actually benefit from drying out between waterings. Similarly, your empathy can lead to misinterpreting signals from your database....

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 24 · 9 min

Enhanced tagging in Postgres Query Insights

As part of yesterday's Traffic Control launch, we made enhancements to the Insights query tagging feature for Postgres databases. Insights has supported query tags for some time, but they were previously only attached as metadata on individual notable query logs. With yesterday's release, tags are n...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 23 · 12 min

Behind the scenes: How Database Traffic Control works

Today, we released Database Traffic Control™, a feature for mitigating and preventing database overload due to unexpectedly expensive SQL queries. For an overview, read the blog post introducing the feature, and to get started using it, read the reference documentation. This post is a deep dive into...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 23 · 4 min

Introducing Database Traffic Control

Postgres has a fundamental gap when it comes to managing query traffic. When an unexpected spike of bad queries, or runaway workload hits your database, Postgres has no good way to fight back. It accepts every query thrown at it until performance degrades or, in the worst case, the server goes down....

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 13 · 10 min

Scaling Postgres connections with PgBouncer

The Postgres process-per-connection architecture has an elegant simplicity, but hinders performance when tons of clients need to connect simultaneously. The near-universal choice for solving this problem is PgBouncer.Though there are upcoming systems like Neki which will solve this problem in a more...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Mar 3 · 2 min

Drizzle joins PlanetScale

I am excited to announce that the Drizzle team is joining PlanetScale to continue their mission of building the best database tools for JavaScript and TypeScript. Drizzle’s ORM has risen to become the default thanks to the team’s obsession with performance and developer experience, two things Planet...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Feb 27 · 7 min

Video Conferencing with Postgres

Yesterday on X, SpacetimeDB tweeted that they had done "the world's first video call over a database" and, in their own way, invited anyone else to give it a try. Credit to them - it's a cool idea! In short, they built a frontend that captures audio and video from the browser's media APIs, encodes t...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Jan 29 · 4 min

Introducing the PlanetScale MCP server

Today we're releasing the new PlanetScale MCP server, bringing your database directly into your AI tools. With the Model Context Protocol (MCP), Claude, Cursor, Open Code, and other AI tools can now connect to the PlanetScale API to help you improve and better understand your database. What is the P...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Jan 14 · 12 min

Database Transactions

Transactions are fundamental to how SQL databases work.Trillions of transactions execute every single day, across the thousands of applications that rely on SQL databases. What is a database transaction? A transaction is a sequence of actions that we want to perform on a database as a single, atomic...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Jan 7 · 4 min

Automating our changelog with Cursor commands

Ever since Cursor commands were released, we've been usingthem to find ways to shortcut common tasks at PlanetScale. A Cursor command allows you to add slash (/actions) commands directly into Cursor. Each command guides the LLM on completing a common and repeatable workflow for you. Updating our cha...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Dec 17 · 2 min

Postgres 18 is now available

Postgres 18 is now available on PlanetScale.Starting today, when you create a new database, the default version will be 18.1.You can select a prior version using the dropdown on the database creation page. This combined with our recent launches of $5 single-node databases and $50 Metal databases mak...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Dec 16 · 3 min

Using MotherDuck with PlanetScale

DuckDB has gained significant traction for OLAP workloads.It's powerful, flexible, and has a feature-rich SQL dialect, making it perfect to use for analytics alongside OLTP-oriented relational databases. Today, we're excited to announce support for the pg_duckdb extension for Postgres databases on P...

0
0 replies
ArticlePlanetScale Blog@planetscale-blog · Dec 15 · 3 min

$50 PlanetScale Metal is GA for Postgres

Today we’re making PlanetScale Metal for Postgres available in smaller sizes and at much lower price points, all the way down to the new M-10 for as little as $50 per month.We’ve lowered the floor from 16GiB of RAM with four sizes all the way to 1GiB and paired these with eight storage capacities ra...

0
0 replies
Learn to build with AI and grow with people doing the same — it's free.