back
user profile

levkk

2,540karma·349submissions·February 9, 2022
about
Sharding Postgres. <https://pgdog.dev>

lev@pgdog.dev

recent activity (349 total)
comment
We don't maintain it anymore. I'm working on pgdog[1] fulltime now. We've had several successful pgcat -> pgdog migrations now. [1] https://github.com/pgdogdev/p…
1h ago·view thread
comment
There is a difference between using an electric drill and having a robot assemble the entire car.
16d ago·view thread
comment
Yup. Getting pretty tired from seeing these "0days" that are not exploitable in any real use case. Just vibes, no substance.
22d ago·view thread
comment
Kagi is amazing. Worth the subscription, 10 times over. I don't have to worry about sponsored search results, or slop from the "AI overview". High quality results, like Google used to b…
25d ago·view thread
comment
This is nonsense. Tokio was built for I/O, not crunching numbers. Most programmers know to use spawn_blocking to crunch 10MB JSON, if needed. Additionally, the proposed workload per thread model …
1mo ago·view thread
comment
I think most tools, according to the UNIX philosophy, do one thing (and do it well). AI is a tool that does _a lot_ of things...to various degrees of success. While you can verify that the output of `…
1mo ago·view thread
comment
Glad you like it. It was built to fix some of PgBouncers shortcomings that we ran into at Instacart many years ago, and to have a stronger foundation for scaling Postgres horizontally (that's sha…
1mo ago·view thread
comment
Ouf. I don't know. I don't want to call you out without evidence -- I myself make benchmark claims all the time -- but 50% improvement in OLTP seems suspicious. I get that you used a standar…
1mo ago·view thread
comment
Pin the client temporarily. I'm assuming that our users know what they are doing. I could be wrong, but so far so good.
1mo ago·view thread
comment
Yes. The plugin architecture supports this currently. That being said, you can use any number of sharding functions we support to do this too.
1mo ago·view thread
comment
Thanks! We try to be very open and explicit about why we chose AGPL. Personally, I like it because it's an extension of GPL, which is a huge reason why I was able to self-teach programming. Just …
1mo ago·view thread
comment
Handling cursors is tough - they are very much session-level objects, so even if we, say, pinned your client while it uses that cursor, which would work, that would decrease the performance of connect…
1mo ago·view thread
comment
I don't think so. Too much trouble. Caching is a really hard problem without context, and the context, typically, is app-specific.
1mo ago·view thread
comment
From the strictest CAP theorem definition, that's correct, it is not. But, it's pretty close. I know that in the database world, that's not a good answer, but in practice, it will deliv…
1mo ago·view thread
comment
Very cool. At first, I thought it was yet another LLM-generated demo, but no: original work of art. Super cool. Transpiling into C does seem easier than LLVM IR, and letting GCC optimize seems like th…
1mo ago·view thread
comment
I cancelled Claude. The harness is kinda broken, GPT 5.5 is good, and GLM 5.2/Deepseek is good too (with pi, especially). Just not worth the trouble. And I'm not going to pay two subscriptio…
1mo ago·view thread
comment
CRUD apps don't usually delete in bulk. It's also hard to structure partitions in a way that doesn't wipe out months of important business data -- this is why teams often ETL their DB i…
2mo ago·view thread
comment
You can have multiple. All sharding is config-based, so no real-time synchronization is required.
2mo ago·view thread
comment
This just checks if the package is installed, not if the installed version is infected. Presumably, if you (me...) haven't run `yay -Syu` in a while (months), we're fine, right? ...Right? Go…
2mo ago·view thread
comment
I didn't realize there are _any_ managed providers of PgDog out there...do tell!
2mo ago·view thread
comment
Awesome, glad it worked!
2mo ago·view thread