levkk

18 ms·

301.
by levkk 3y ago
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 just 128 connections and a pooler. So I
302.
Making Postgres 30 Percent Faster in Production(postgresml.org)
3 points by levkk 3y ago|0 comments
303.
Making Postgres 30 Percent Faster in Production(postgresml.org)
15 points by levkk 3y ago|0 comments
304.
by levkk 3y ago
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.
305.
by levkk 3y ago
Links: [1]: https://huggingface.co/spaces/mteb/leaderboard [2]: https://postgresml.org/blog/generating-llm-embeddings-with-o... [3]: https://postgresml.org/blog/tuning-ve
306.
Show HN: We unified LLMs, vector memory, ranking, pruning models in one process
4 points by levkk 3y ago|1 comments
307.
PostgresML raises $4.7M to launch AI application databases based on Postgres(postgresml.org)
6 points by levkk 3y ago|0 comments
308.
Pg_stat_sysinfo(github.com)
1 points by levkk 3y ago|0 comments
309.
PG Stat Sysinfo, a Postgres Extension for Querying System Statistics(postgresml.org)
2 points by levkk 3y ago|0 comments
310.
Tuning vector recall while generating query embeddings in the database(postgresml.org)
1 points by levkk 3y ago|0 comments
311.
Tuning vector recall while generating query embeddings in the database(postgresml.org)
3 points by levkk 3y ago|0 comments
312.
Generating LLM embeddings with open source models in PostgresML(postgresml.org)
4 points by levkk 3y ago|0 comments
313.
Generating LLM embeddings with open source models in PostgresML(postgresml.org)
5 points by levkk 3y ago|0 comments
314.
Generating LLM embeddings with open source models in PostgresML(postgresml.org)
3 points by levkk 3y ago|0 comments
315.
Adopting PgCat: A Nextgen Postgres Proxy(tech.instacart.com)
2 points by levkk 4y ago|0 comments
316.
by levkk 4y ago
Yeah, but I remember the plugin ignoring that setting.
317.
by levkk 4y ago
Last time I checked there was no support for synchronous logical replication in the `pglogical` plugin that's used for logical decoding. Did something change lately?
318.
Adopting PgCat: A Nextgen Postgres Proxy(tech.instacart.com)
2 points by levkk 4y ago|0 comments
319.
Adopting PgCat: A Nextgen Postgres Proxy(tech.instacart.com)
2 points by levkk 4y ago|0 comments
320.
by levkk 4y ago
I like. I had to do something similar a while back as part of an ETL pipeline.
321.
Scaling PostgresML to 1 Million Requests per Second(postgresml.org)
3 points by levkk 4y ago|0 comments
322.
by levkk 4y ago
We're using persistent connections for Python/Gunicorn as well. See the Methodology section for more details.
323.
by levkk 4y ago
If I turn that into a single line and that improves performance 40x... I will probably not do engineering for a while after that.
324.
by levkk 4y ago
- We compared MessagePack as well, that's your typical binary format. It ended up being slower, which is what I've seen before when storing small floats (a typical ML feature). It's in the article with a whole section dedicat
325.
by levkk 4y ago
PostgresML v1.0 was doing exactly that. When we rewrote in Rust for v2.0, we improved 35x: https://postgresml.org/blog/postgresml-is-moving-to-rust-for...
326.
by levkk 4y ago
We have LightGBM also. The entire Scikit library is available (although via a Python wrapper) and a couple algorithms from Linfa (a Rust Scikit rewrite). We will be adding more algorithms and move to Rust entirely for v3.0.
327.
by levkk 4y ago
Link: https://postgresml.org/blog/postgresml-is-8x-faster-than-pyt...
328.
by levkk 4y ago
My bad. Here it is: https://postgresml.org/blog/postgresml-is-8x-faster-than-pyt...
329.
Machine learning in the database is 40 times faster than in a microservice
22 points by levkk 4y ago|6 comments
330.
PostgresML is 8-40x faster than Python HTTP microservices(postgresml.org)
2 points by levkk 4y ago|0 comments

More ›