Lightnews — Scholar-powered news

PlanetScale @planetscale.com · 2d

PlanetScale Metal continuously comes out on top compared to other cloud database providers. Unlike other options w/ local NVMe drives, PlanetScale Metal runs in AWS and GCP, not our own data centers.

This make for a blazing fast database while staying close to your other infrastructure.

5

PlanetScale @planetscale.com · 3d

We've added 5 new columns to Insights for Postgres databases.

These reveal block-level read and write behavior, helping you better understand the effect of the shared buffer cache on your query performance.

Read more: planetscale.com/changelog/po...

6

Reposted by PlanetScale

Ben @benjdd.com · 4d

I benchmarked 96 combinations of Postgres 17 and 18.

There's a few surprising results, but overall Postgres 18 has some nice improvements.

Read all about it at the link below.

1 1 5

PlanetScale @planetscale.com · 4d

planetscale.com/blog/benchma...

Benchmarking Postgres 17 vs 18 — PlanetScale

Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17.

planetscale.com

1

PlanetScale @planetscale.com · 4d

Postgres 17 vs 18.

How does read performance compare between the two? What is the best server configuration to maximize performance?

Check out our latest blog for detailed benchmarks.

1 5

PlanetScale @planetscale.com · 10d

New region alert! 🌍

You can now create Postgres and Vitess databases in the europe-west1 region in GCP (Belgium).

4

PlanetScale @planetscale.com · 11d

Thinking about using UUIDs as primary keys? Read this first.

In short, random UUIDs can negatively impact database performance with page splits, 4-9x storage overhead, and slower inserts. Use v7 or consider alternatives like BIGINT or NanoIDs.

planetscale.com/blog/the-pro...

The Problem with Using a UUID Primary Key in MySQL — PlanetScale

Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.

planetscale.com

3

PlanetScale @planetscale.com · 12d

Schema recommendations are available for Postgres databases. We analyze your database daily and provide recommendations for optimization:

- Remove redundant indexes
- Prevent primary key ID exhaustion
- Drop unused tables and indexes
- Rebuild bloated tables and indexes

1 7

PlanetScale @planetscale.com · 17d

Read it on our blog:
planetscale.com/blog/larger-...

Larger than RAM Vector Indexes for Relational Databases — PlanetScale

A new hybrid design for scalable vector indexes and a reference implementation in MySQL

planetscale.com

PlanetScale @planetscale.com · 17d

Vitess databases on PlanetScale support sophisticated vector search.

We've published a deep-dive on how we built this for MySQL in a way that is scalable, performant, and ACID-compliant.

1 1 4

PlanetScale @planetscale.com · 18d

If you want to hear real-world stories about how companies handle millions of QPS, swing by tomorrow's Vitess Night at the PlanetScale office. You won't want to miss our 2 featured talks:

- How Slack runs Vitess
- Incoming Query Throttler at Uber

RSVP:
luma.com/3qp4pjhu

Vitess Night · Luma

We're excited to announce the second ever Vitess Night! The night will include talks from some of the world's largest Vitess users like Uber and Slack, plus…

luma.com

1

PlanetScale @planetscale.com · 19d

Check it out here:
github.com/planetscale/...

GitHub - planetscale/migration-scripts: Scripts for migrating from Postgres to PlanetScale

Scripts for migrating from Postgres to PlanetScale - planetscale/migration-scripts

github.com

1

PlanetScale @planetscale.com · 19d

Migrate your Postgres database to PlanetScale, fast.

Our migration-scripts repo has tools for migrating:

- Postgres → PlanetScale PG (Logical or DMS)
- Heroku PG → PlanetScale PG (via Bucardo)
- Postgres → Vitess

1 2

PlanetScale @planetscale.com · 22d

We just added 4 new Insights columns for Postgres databases to track per-query pattern CPU and I/O utilization.

- Cumulative CPU time
- Cumulative I/O time
- % of CPU time
- % of I/O time

1 3

PlanetScale @planetscale.com · 23d

We've partnered with @cloudflare.social to make it easy to ship full-stack apps backed by Postgres or Vitess and Cloudflare Workers.

Sign in to your PlanetScale or Cloudflare account to get started and scale to millions.

planetscale.com/blog/partner...

Partnering with Cloudflare to bring you the fastest globally distributed applications — PlanetScale

You can now easily set up PlanetScale databases with Cloudflare Workers using this native integration.

planetscale.com

2 8

PlanetScale @planetscale.com · 24d

Give it a read:
planetscale.com/blog/process...

Processes and Threads — PlanetScale

Processes and threads are fundamental abstrations for operating systems. Learn how they work and how they impact database performance in this interactive article.

planetscale.com

3

PlanetScale @planetscale.com · 24d

Postgres: process-per-connection

MySQL: thread-per-connection

Learn more about processes, threads, connection pooling, and how they impact database performance in our latest interactive article.

1 5

PlanetScale @planetscale.com · 26d

We’re hosting a livestream in 1 hour where we’ll give you an overview of PlanetScale for Postgres and answer all of your questions. Watch on YouTube or on X.

www.youtube.com/watch?v=IQMX...

Postgres is now GA

YouTube video by PlanetScale

www.youtube.com

1

PlanetScale @planetscale.com · 26d

We’ve also revamped our documentation with @mintlify.bsky.social to better support the addition of our new Postgres product. You can find the dedicated PlanetScale for Postgres documentation here:

planetscale.com/docs/postgres

PlanetScale for Postgres documentation - PlanetScale

planetscale.com

1 2

PlanetScale @planetscale.com · 26d

PlanetScale for Postgres is now GA.

planetscale.com/blog/planets...

PlanetScale for Postgres is now GA — PlanetScale

PlanetScale for Postgres is now generally available.

planetscale.com

1 9 22

PlanetScale @planetscale.com · Sep 12

We just posted a new blog about how a lagging Postgres replication client can stall or break failover with HA Postgres, and how MySQL’s GTID model avoids this:
planetscale.com/blog/postgre...

Postgres High Availability with CDC — PlanetScale

Why a lagging client can stall or break failover, and how MySQL’s GTID model avoids it.

planetscale.com

5

PlanetScale @planetscale.com · Sep 10

📅 Join PlanetScale and @convex.dev on 9/24 for an evening of lightning talks, an expert panel, and networking.

We'll explore how your database choice can impact your ability to scale + how great database DX prevents operational pain down the road.

luma.com/dxanddbv1

DX and Databases for Startups that Scale with PlanetScale & Convex · Luma

About Event Join us for the DX and Databases night with PlanetScale and Convex. Topic: DX and databases for startups that scale with PlanetScale and Convex. …

luma.com

3

PlanetScale @planetscale.com · Sep 8

Minimizing query latency is crucial for keeping your databases performant and your applications fast.

Learn how to use Insights to identify slow queries.

2

PlanetScale @planetscale.com · Sep 4

Read the changelog:
planetscale.com/changelog/ex...

Expanded Postgres network-attached storage I/O configuration — PlanetScale

The latest PlanetScale features and product launches.

planetscale.com

PlanetScale @planetscale.com · Sep 4

We give users full control over the size and capabilities of their network-attached Postgres storage. Tune minimum size, maximum autoscaling, IOPS, and throughput.

1 2