Re: Unlogged vs. In-Memory

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. +