persistent read cache

From: Sand Stone <sand(dot)m(dot)stone(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: persistent read cache
Date: 2018-02-11 19:34:52
Message-ID: CADrk5qNhatrzJW+jwGZ9bh_uRDODb9iAouhuzq9+H1NPpaP0Pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Paris 2018-02-11 20:00:12 Re: New Copy Formats - avro/orc/parquet
Previous Message Andres Freund 2018-02-11 17:16:53 Re: New Copy Formats - avro/orc/parquet

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2018-02-11 20:23:43 Re: [HACKERS] Fix warnings and typo in dshash
Previous Message Merlin Moncure 2018-02-11 15:00:24 Re: JIT compiling with LLVM v9.0