zlacker

[return to "PostgresML is 8-40x faster than Python HTTP microservices"]
1. chaps+b5[view] [source] 2022-10-20 01:45:53
>>redbel+(OP)

  "In Python, most of the bottleneck comes from having to fetch and deserialize Redis data."
This isn't a fair comparison. Of freaking course postgres would be faster if it's not reaching out to another service.
◧◩
2. montan+b7[view] [source] 2022-10-20 02:09:07
>>chaps+b5
As a contributor, I think it's interesting when comments focus on the language (Python vs Rust) vs the architecture (local vs remote). Inference is embarrassingly parallelizable, with Python Flask or Postgres replicas. I think the interesting thing is that data retrieval costs tend to dominate other costs, and yet are often ignored.

ML algorithms get a lot focus and hype. Data retrieval, not as much.

◧◩◪
3. deepst+hE[view] [source] 2022-10-20 08:29:48
>>montan+b7
that is reason many older developer tend to do everything biz logic etc all in db store procedure/functions/view, etc. The cost of getting the data is native, no connection pooling needed, and with V8/python integration in the PG, it is non trivial what language you use. If you are dealing with large amount of data in a db, why not just do everything there. DB like sql has cursor, merge, that makes manipulating large set of data much easier than moving it on to another language environment.
[go to top]