Horton

Re: Unlogged vs. In-Memory

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, Magnus Hagander <magnus@hagander.net>, Alvaro Herrera <alvherre@commandprompt.com>, Thom Brown <thom@linux.com>, Rob Wultsch <wultsch@gmail.com>, Joshua Berkus <josh@agliodbs.com>, PostgreSQL Advocacy <pgsql-advocacy@postgresql.org>
Date: 2011-05-13T20:52:30Z
Lists: pgsql-hackers 
Robert Haas wrote:
> On Thu, May 5, 2011 at 3:00 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> >> However, it would in a lot of cases be very useful to have osmething
> >> like CREATE TEMPORARY TABLESPACE <blah>. Which would only accept
> >> temporary (and maybe unlogged) tables. And then would auto-create the
> >> PG_<version>_<catversion> directory upon startup.
> >>
> >> That's obviously a 9.2 feature though, it's not an adjustment of an
> >> existing one, it's brand new :-)
> >
> > Yes, that's a nice feature for 9.2
> 
> +1.  That's a really nice idea.

Added to TODO:

	Allow tablespaces on RAM-based partitions for unlogged tables
	
	    * http://archives.postgresql.org/pgsql-advocacy/2011-05/msg00033.php 

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +