Postgres Pro
Downloads
Home   >   mailing lists

Re: Redis 16 times faster than Postgres? - Mailing list pgsql-general

From Imre Samu
Subject Re: Redis 16 times faster than Postgres?
Date
Msg-id CAJnEWw=aPmFnbp5Phev=p=91JcdN3MV6Ry+CO_MY+bQKLuBWqA@mail.gmail.com
Whole thread Raw
In response to Redis 16 times faster than Postgres?  ("Colin 't Hart" <colinthart@gmail.com>)
List pgsql-general
Tree view
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:
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: 

Imre


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

Can someone take a look at this blog post?

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

pgsql-general by date:

Previous
From: Gerrit Fouche
Date:
Subject: pg_upgrade (Checking for reg* data types)
Next
From: Devrim Gündüz
Date:
Subject: Re: pg12 rc1 on CentOS8 depend python2