back
user profile
levkk
2,540karma·349submissions·February 9, 2022
about
Sharding Postgres. <https://pgdog.dev>
lev@pgdog.dev
recent activity (349 total)
comment
> Zed requires a physical GPU with a Vulkan 1.3 driver. That's new. Does everyone running Linux have a dedicated GPU these days? Only caught this because I'm in the middle of updating my …
comment
Setting up and running IRC requires some time and knowledge most companies don't want to invest in. It's much easier to buy than to build, especially when it's not your core competency.…
comment
That remains a mystery for now. We measured upload speeds to S3 to be upwards of 700MB/second (still not 12,800MB/second you'd hope for, but S3 has to write to disk(s)). Download speeds…
comment
I'd say hacking isn't the same as building new production quality features. Just for fun or for educational purposes, I'd want to change something about the database, and it won't …
comment
Pretty cool. A little slow for a search engine, have you tried in-database embeddings for semantic search like PostgresML?
comment
You'd have to try very hard to override a type in Rust when that type comes directly from your database (see SQLx). Rust unsafe features don't allow you to override type safety, but you can …
comment
We've been using Turbo for over a year now (similar idea to Htmx). Pretty happy not to be using React anymore. Most of the complexity is offloaded to the backend where we can handle it better wit…
comment
I don't know, "blog written in C" is way more interesting than "blog written in PHP".
comment
The UI is much faster than Github, which is great, big selling point for me. The "iterative change" approach is pretty much how companies use Github I think. Contributors are given push perm…
comment
What about changing iops or storage class?
comment
Curious about the "outside of the database" index generation part. Is this index WAL-protected eventually?
comment
In the case of running Postgres on K8s, the problem arises immediately when you try to resize a data volume and you can't because the API doesn't support it. K8s is not really for stateful s…
comment
Same, this is depressing
comment
Same experience here, getting really low fps just moving around in an empty scene.
comment
Running this exact implementation with 47M jobs processed and counting. SKIP LOCKED is great for VACUUM, and having durable storage with indexes make otherwise expensive patterns like delayed jobs, re…
comment
How about the one that works directly in your database: https://postgresml.org
comment
Pretty sure Tom Lane said this will be a disaster in that same pgsql-hackers thread. Not entirely sure what benefits the multi-threaded model will have when you can easily saturate the entire CPU with…
comment
If you want to try some open source LLMs, try our free serverless tier on PostgresML.org! You can run any LLM from HuggingFace and fine tune your own.
comment
Links: [1]: https://huggingface.co/spaces/mteb/leaderboard [2]: https://postgresml.org/blog/generating-llm-embeddings-with-o... [3]: https://…