Re: Redis 16 times faster than Postgres?

[Imre Samu <pella.samu@xxxxxxxxx>]

from the original article:
> For example, the PostgreSQL speeds depend on the Django ORM code 

> that makes the SQL and sends the query and then turns it into the model instance.

> I don't know what the proportions are between that and 

> the actual bytes-from-PG's-disk times. But I'm not sure I care either. 

imho:   the "Django ORM" is not so fast.

according to "TechEmpower Web Framework Benchmarks" ...  

it has only  ~3% performance  -  compare to the best rust+pg (100%) results.

example:

"Data updates" https://www.techempower.com/benchmarks/#section=data-r18&hw=ph&test=update 

the "django-postgresql" performance = 766   - only 3.0% of the best pg + rust results

checking the other test types (  "Single query" ;" Multiple queries" ) has a similar results.

the Django implementation of the test: 

https://github.com/TechEmpower/FrameworkBenchmarks/tree/master/frameworks/Python/django

Imre

Colin 't Hart <colinthart@xxxxxxxxx> ezt írta (időpont: 2019. szept. 29., V, 23:42):

Hi,

Can someone take a look at this blog post?

https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json

Can Redis really be 16 times faster than Postgres? Surely Postgres can get closer to the raw speed of the hardware than 1 order of magnitude?

Thanks,

Colin