Horton

Re: Unlogged vs. In-Memory

Thom Brown <thom@linux.com>

View thread
From: Thom Brown <thom@linux.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Magnus Hagander <magnus@hagander.net>, Rob Wultsch <wultsch@gmail.com>, PostgreSQL Advocacy <pgsql-advocacy@postgresql.org>
Date: 2011-09-23T01:26:53Z
Lists: pgsql-hackers 
On 22 September 2011 17:38, Josh Berkus <josh@agliodbs.com> wrote:
>
>> So are there any plans to allow swappable drive/volatile storage
>> unlogged tables?
>
> Be our guest.  ;-)

Oh it can't be that difficult.  On first glance it looks like it's a
case of piggy-backing mdopen and getting it to treat
RELPERSISTENCE_TEMP relations in the same way as it would for
relations during the bootstrap script (i.e. create it if it doesn't
exist)... then telling it not to try reading anything from the
relation... or something like this.  But I don't know C so...
*puppy-dog eyes*

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company