Sequences and other volatiles in Neki
How Neki evaluates PostgreSQL volatile expressions with the right cardinality to preserve sequence semantics across shards.
پایگاهداده در مقیاس: MySQL، Postgres و Vitess.
How Neki evaluates PostgreSQL volatile expressions with the right cardinality to preserve sequence semantics across shards.
PlanetScale Postgres and Neki databases can now be deployed on Microsoft Azure
Postgres 19 switches TOAST compression from pglz to LZ4. LZ4 is faster, but it isn't always smaller, and some reads get slower with it.
TIN v1.0.6 supports stemming in 18 languages and is 2 3x as fast as the GA version
Admission controls in software determine what does or doesn't happen next, and the most common implementation has ancient roots.
Use dedicated read replicas to isolate read only workloads and distribute your data across data centers around the world.
Nothing is as fast as not doing anything. How Neki keeps great performance by only decoding the parts of a PostgreSQL result the router actually needs.
What makes a good sharding strategy today might not work so well tomorrow. What happens when you have one tenant hitting your database orders of magnitude more than any other? Or product managers knocking down your door with new requirements? If you're already on Neki, fortunately these are issues we can solve.
ARM and x86 can give you different performance at the same vCPU count. Here's what differs, what to measure, and how to choose.
A good Postgres search demo was doing the rounds online. Let's see what happens when we upgrade it to TIN.