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

From Ben Chobot
Subject Re: Redis 16 times faster than Postgres?
Date
Msg-id 53446CE1-5E1D-4A1A-A56C-FBBAB0B250F5@silentmedia.com
Whole thread Raw
In response to Re: Redis 16 times faster than Postgres?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On Sep 29, 2019, at 8:44 PM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> On 9/29/19 8:09 PM, Steve Litt wrote:
>> On Mon, 30 Sep 2019 07:46:14 +1000
>> Nathan Woodrow <madmanwoo@gmail.com> wrote:
>>
>>> Redis is a in memory database so I would except it to be always much
>>> faster..
>> Is there a way to have Redis periodically update an on-disk backup?
>> That would be great, but otherwise you're at the mercy of your power
>> company (here in Central Florida it's routine for power to go down and
>> stay down for five hours).
>
> It would be criminal for it not to have an async writer process flushing modified pages to disk.  And to not have a
UPSthat you've tested. 

It's perfectly reasonable to use Redis as a caching layer without any persistence at all. In such cases, flushing state
todisk is a waste of resources.  

(For other use cases, yes, Redis allows you to flush state to disk.)


pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Redis 16 times faster than Postgres?
Next
From: Andrew Gierth
Date:
Subject: Re: Possible bug: SQL function parameter in window frame definition