Skip site navigation (1) Skip section navigation (2)

swapcache-style cache?

From: james <james(at)mansionfamily(dot)plus(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: swapcache-style cache?
Date: 2012-02-22 22:31:27
Message-ID: 4F456CBF.10504@mansionfamily.plus.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Has anyone considered managing a system like the DragonFLY swapcache for 
a DBMS like PostgreSQL?

ie where the admin can assign drives with good random read behaviour 
(but perhaps also-ran random write) such as SSDs to provide a cache for 
blocks that were dirtied, with async write that hopefully writes them 
out before they are forcibly discarded.

And where a cache fail (whether by timeout, hard fail, or CRC fail) just 
means having to go back to the real transactional storage.

I'd been thinking that swapcache would help where the working set won't 
fit in RAM, also L2ARC on Solaris - but it seems to me that there is no 
reason not to allow the DBMS to manage the set-aside area itself where 
it is given either access to the raw device or to a pre-sized file on 
the device it can map in segments.

While L2ARC is obviously very heavyweight and entwined in ZFS, 
Dragonfly's swapcache seems to me remarkably elegant and, it would seem, 
very effective.

James

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-02-22 22:49:26
Subject: Re: pg_upgrade --logfile option documentation
Previous:From: Robert HaasDate: 2012-02-22 22:02:43
Subject: Re: VACUUM ANALYZE is faster than ANALYZE?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group