Lightnews — Scholar-powered news

Larger than RAM Vector Indexes for Relational Databases — PlanetScale

PlanetScale @planetscale.com · 6d

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 · 11d

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

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

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…

PlanetScale @planetscale.com · 11d

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 · 12d

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

luma.com

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

PlanetScale @planetscale.com · 13d

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

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

github.com

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

PlanetScale @planetscale.com · 13d

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 · 16d

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 · 17d

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...

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

Processes and Threads — PlanetScale

2 8

PlanetScale @planetscale.com · 18d

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

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

YouTube video by PlanetScale

PlanetScale @planetscale.com · 18d

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 · 20d

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

www.youtube.com

PlanetScale for Postgres documentation - PlanetScale

PlanetScale @planetscale.com · 20d

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 is now GA — PlanetScale

1 2

PlanetScale @planetscale.com · 20d

PlanetScale for Postgres is now GA.

planetscale.com/blog/planets...

PlanetScale for Postgres is now generally available.

Postgres High Availability with CDC — PlanetScale

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...

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

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

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

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

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

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...

The latest PlanetScale features and product launches.

We're covering all the basics of how PlanetScale works, both for Postgres and Vitess databases. Learn about high-availability configurations, insights, metrics, sharding, and more. We'll also be answe...

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

PlanetScale @planetscale.com · Sep 2

Join us in 1 hour for our next livestream - Introduction to PlanetScale. We'll cover:

- High-availability configurations
- Query Insights and metrics
- Sharding
- And more

Register below:

streamyard.com/watch/zXmGRU...

Intro to PlanetScale

streamyard.com

PlanetScale @planetscale.com · Aug 29

Next Livestream: Intro to PlanetScale!

We'll cover high-availability configurations, Query Insights, metrics, and show sharding in action.

Tuesday 9AM PST. Sign up at the link below.

streamyard.com/watch/zXmGRU...

Intro to PlanetScale

We're covering all the basics of how PlanetScale works, both for Postgres and Vitess databases. Learn about high-availability configurations, insights, metrics, sharding, and more. We'll also be answe...

streamyard.com

PlanetScale CLI for Postgres — PlanetScale

PlanetScale @planetscale.com · Aug 25

PlanetScale Metal runs in AWS and GCP, making it easy to deploy your database and application near each other.

1 3

PlanetScale @planetscale.com · Aug 20

Our CLI allows you to spin up new branches, manage roles, and even install the PlanetScale MCP server to interact with your database.

Now supported in PlanetScale for Postgres:

planetscale.com/docs/postgre...

Learn how to use PlanetScale to power your application.

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

PlanetScale @planetscale.com · Aug 18

Postgres 13 EOL! Migrate to version 17.

YouTube video by PlanetScale

www.youtube.com