Re: Unlogged vs. In-Memory

From: Thom Brown <thom(at)linux(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, 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-09-22 08:36:50
Message-ID: CAA-aLv6BGUQ2Nx_nhpL=Bcz0XGOnKOOWQroDbcJVmJv8uynB6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

On 4 May 2011 16:30, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Wed, May 4, 2011 at 3:02 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
>> To make PG do it automatically, we'd need to store the _init forks in
>> a different tablespace from the remaining forks.  That's probably
>> possible, but it seems complicated.
>
> Sounds much better way actually and also quite easy. All we do is keep
> the init forks in a subdirectory that identifies the tablespace they
> relate to.

So are there any plans to allow swappable drive/volatile storage
unlogged tables?

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

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

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Josh Berkus 2011-09-22 16:38:01 Re: Unlogged vs. In-Memory
Previous Message Gabriele Bartolini 2011-09-19 14:13:48 Re: Links for 9.1 press coverage

Browse pgsql-hackers by date

  From Date Subject
Next Message Gunnlaugur Þór Briem 2011-09-22 09:43:25 Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions
Previous Message Tom Lane 2011-09-22 06:41:12 Re: EXPLAIN and nfiltered, take two