Re: Unlogged vs. In-Memory

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Thom Brown <thom(at)linux(dot)com>, Rob Wultsch <wultsch(at)gmail(dot)com>, Joshua Berkus <josh(at)agliodbs(dot)com>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Unlogged vs. In-Memory
Date: 2011-05-13 20:52:30
Message-ID: 201105132052.p4DKqUV19009@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

Robert Haas wrote:
> On Thu, May 5, 2011 at 3:00 PM, Simon Riggs <simon(at)2ndquadrant(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2011-05-13 20:54:34 Re: Unlogged vs. In-Memory
Previous Message Selena Deckelmann 2011-05-13 19:49:09 Re: Changing the sponsors page

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-05-13 20:54:34 Re: Unlogged vs. In-Memory
Previous Message Noah Misch 2011-05-13 20:16:13 Reducing overhead of frequent table locks