Hacker Newsnew | past | comments | ask | show | jobs | submit | bddicken's commentslogin

This is changing soon with Neki.

https://www.neki.dev


Nice. But it's not even available yet.

It will take years to call this mature. Certainly not "soon"


For me that page has basically 0 descriptive content.


Love how easy it is to visually correlate schema changes to performance improvements in Insights.


Hi, author of the blog here. Benchmarking can be tricky, but I did my best to make this fair and useful to other DB engineers. Ask me anything!


Author of the article here. Hope you love it, and I'm hanging around to answer any questions.


A fine introduction, but a few nits.

Similar to how in the "POSIX threads" section you indicate that pthread_create() is UNIX/POSIX-specific, you should probably indicate in the "Creating new Processes" section that fork() and execve() are Unix/POSIX-specific. That, or you could indicate that you are describing generally in that context.

In "Running multiple programs" you state: "After a few seconds, it pauses, saves the state of the RAM, and changes processes." Saying it "saves the state of the RAM" is probably not a good characterization since it is more likely just changing what memory is accessible. It is also, most likely changing the virtual memory mappings to give the illusion of using the same memory addresses (though it does not have to, for instance a system with a MPU still has a concept of distinct programs even though virtual memory mappings are not supported), but you could omit that to the later virtual memory section without being incorrect.


Thanks for the feedback!

Yeah, I purposefully "simplified" how virtual memory works here so that the focus could be on multitasking and context switching, but agree that isn't totally accurate. I actually had hoped to do a part II on virtual memory, but we'll see if time permits that :)


Really great post with that interactive examples and the example of mysql x postgrel too.

I would like read more about that topics with that level of detail.


Its a great blog post and loved the interactive elements around it


awesome work, really enjoyed this


Thank you!


Still in virtual machines, but ones with local NVMe drives rather than network-attached storage (EBS, Persistent Disk). This means incredible I/O performance.

https://planetscale.com/blog/benchmarking-postgres


It's real Postgres operated by PlanetScale. You get HA by default, the best performance, query insights, etc.

https://planetscale.com/blog/benchmarking-postgres


In the database world, serverless/autoscaling pricing is almost always more expensive for real workloads. The % of workloads where it makes sense is small. Ones where 90% of the time there's little small traffic and 10% of the time the DB sees large traffic spikes. Otherwise, just pay a fixed cost for the hardware you need.


Why? Neki is built by the the engineers who have built, maintain, and operate massive-scale Vitess databases.


To add to this, if you look at the top 10 committers to Vitess over the last 12 months, 8 of them are helping with Neki in one way or another:

https://github.com/vitessio/vitess/graphs/contributors?from=...


Multigres is made by the guy that made Vitess, Sugu, before it became a startup. Doesn't mean it will be better, but I think it's why people have high hopes for both products.


there are also a significant number of previous vitess maintainers that have gone to supabase to work on it with him, so there's that.

it is not at all accurate to say that neki is made by "the team that brought you vitess" and that multigres is somehow not


You forgot the read the original text above my response.

> I looked Neon recently, and it appears that it's designed as a SaaS product from the outset; while it is technically possible to self-host the individual components of the architecture, it does not look trivial, in large part because the control plane is closed source (and probably extremely specific to Neon's SaaS operations).

This is a good reason to go with multigres vs Neki (assuming Neki gets integrated into planetscale vs a standalone multigres ).

The two announcement's regarding Neki smells like its going to be proprietary or heavily tied into planetscale. See the gauging interest two months ago with sign ups. The current signing up ... Feel very marketing focused.

https://planetscale.com/blog/planetscale-for-postgres#nova-v...

> If your company runs Postgres at a significant scale and this is something that interests you, reach out.

> Sign up for the private preview of PlanetScale for Postgres waitlist here.

https://planetscale.com/blog/announcing-neki

> To stay up to date with the latest developments on Neki you can signup at neki.dev.

Where as the multigres via Supabase points to github repo's, the license, etc...

https://supabase.com/blog/multigres-vitess-for-postgres

> Like Vitess, Multigres will be open source using the same license: Apache 2. You can follow the repo here.

We shall see, but one is running and acting like pure open source project, and another is being announced how the marketing department of a proprietary software company works.

And the timing is interesting. Coincidence that both Neki and multigres got announced right at the same time? I am suspecting there has been some background drama going on with planetscale and supabase. But that is off-topic.

Like i said, and i agree with the poster i responded too: That Neki smells like its going to be tied into planetscale.


The Postgres team incorporating io_uring into PG 18 is a good example of this: https://pganalyze.com/blog/postgres-18-async-io.


This was a great read - thanks!


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: