These updates bridge the gap between traditional Postgres and distributed sharding. With read-only replicas, Azure support, and massive performance boosts to bulk writes, Neki offers a scalable path for Postgres workloads without sacrificing SQL compatibility or developer experience.
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 evaluating Neki for your workload today.
We've recently added both read-only replicas and smaller Metal instances to Neki starting at just $50 per month.
Read-only replicas were a hotly-requested feature for Postgres, particularly for customers with a large, global userbase. Neki now also supports read-only replicas for shards in your cluster.
We also now support smaller Metal node sizes, going all the way down to database nodes with 1/8th vCPU, 1GB RAM, and 10GB of locally-attached NVMe SSD.
You can try both of these capabilities on Neki in PlanetScale today. These are just a few amongst many others, including:
extensions in a planetscale_neki_configuration_profile resource or with pscale branch config-profile update --extensions, and change their settings in the same update.planetscale_get_branch_metrics pulls CPU, memory, disk, replication lag, and connections into your AI agent, or wherever you connect to your infrastructure via MCP. It works for Neki, Postgres, and Vitess.planetscale_neki_router, and the planetscale_databases data source can now filter by kind (mysql, postgresql, or neki).requires_update field in JSON output.huge_pages to on in a configuration profile's Parameters tab on supported cluster sizes. The change requires a restart.Much of the engineering effort since preview has gone into the query layer: making more of your existing SQL run on a sharded database without changes, and making the standard Postgres tools you already use work against Neki.
The team has merged more than 650 changes since the preview opened. A few more highlights:
UPDATE ... FROM, DELETE ... USING and MERGE, correlated EXISTS almost anywhere in a query, ARRAY(SELECT ...), SQL cursors, LISTEN/NOTIFY, materialized views, and PL/pgSQL exception handlers are all now supported.COPY ... TO STDOUT now works on sharded tables in text, CSV, and binary, so pg_dump and other export tools can read data out of a sharded Neki database.INSERT ... SELECT is about 76x faster than at launch, and COPY ingest is roughly 5x faster.EXPLAIN (NEKI_PG_PLAN) shows Neki's distributed plan together with the Postgres plan each shard ran. The output follows Postgres's own EXPLAIN format, so pgAdmin, DBeaver, explain.dalibo.com, and explain.depesz.com can read it.If you're running Postgres and expect to need sharding or any other Neki features like online schema changes or no downtime version upgrades, now is a good time to start the conversation. Email us at neki@planetscale.com or fill out the form, and we'll set up a call with our solutions team.
If you want to learn more about Neki, we recommend starting with When to shard, Neki best practices, and Data topology.
Continue reading on the original blog to support the author
Read full articleThis expansion allows Azure-based teams to utilize PlanetScale's managed database features with low latency. The technical implementation highlights sophisticated Kubernetes networking strategies to overcome cloud provider IP limitations at scale.
This feature allows engineers to scale read-heavy Postgres workloads globally while isolating specialized tasks like analytics or vector search. By providing independent resource tuning for each replica, teams can optimize performance and costs without impacting the primary database.
Sharding strategies that work at launch often fail under scale. Understanding how to migrate from tenant-based sharding to more granular keys is crucial for maintaining performance and enabling features like cross-tenant communication without incurring application downtime.
Logical replication slots are vital for data integrity in downstream systems. By blocking cutovers until slots are synced, PlanetScale prevents silent data loss in CDC pipelines, ensuring high availability doesn't compromise consistency for external analytics or search indexes.