Fwd: persistent read cache - Mailing list pgsql-general

From Sand Stone
Subject Fwd: persistent read cache
Date
Msg-id CADrk5qNZQGwJyjJLxKERE3it=8N9i712XVsK68UzVBPcKbi05Q@mail.gmail.com
Whole thread Raw
Responses Re: persistent read cache  (Steve Atkins <steve@blighty.com>)
List pgsql-general
Posted to the wrong alias. Just wonder if anyone else feels such a use
case.  Thanks.

---------- Forwarded message ----------
From: Sand Stone <sand.m.stone@gmail.com>
Date: Sun, Feb 11, 2018 at 11:34 AM
Subject: persistent read cache
To: pgsql-hackers@lists.postgresql.org


Hi. I wonder if there is such a thing or extension in the PG world.

Here is my use case. I am using PG (PG10 to be more specific) in a
cloud VM environment. The tables are stored in RAID0 managed SSD
backed attached storage. Depending on the VM I am using, I usually
have 256GB local SSD unused.

I wonder if PG could leverage this local SSD as a read (page/block)
cache, to complement/extend  the DRAM by used by shared_buffer today.

Thanks.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: New Copy Formats - avro/orc/parquet
Next
From: Durumdara
Date:
Subject: Remove default privilege from DB