Re: Unlogged vs. In-Memory

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Rob Wultsch <wultsch(at)gmail(dot)com>, Joshua Berkus <josh(at)agliodbs(dot)com>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: Unlogged vs. In-Memory
Date: 2011-05-03 18:44:27
Message-ID: BANLkTinzAEi0ZWOejfG4gyq7+BaTcXChNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

On Tue, May 3, 2011 at 20:06, Thom Brown <thom(at)linux(dot)com> wrote:
> On 3 May 2011 19:02, Rob Wultsch <wultsch(at)gmail(dot)com> wrote:
>> Can Unlogged tables be located on a table space mount on a ram fs
>> without hosing the instance if the server gets bounced?
>
> No more than anything else in a RAM filesystem.  There are of course
> battery-backed RAM disk devices people can use, but those are a
> special case.

I think you're missing the scenario Rob is talking about. I think he
mentions the sequence:

CREATE TABLESPACE junk LOCATION '/tmp/junk';
CREATE UNLOGGED TABLE meh(a int) TABLESPACE junk;
<stop server>
rm -rf /tmp/junk/*
<start server>
postgres=# select * from meh;
ERROR: could not open file
"pg_tblspc/16434/PG_9.1_201104251/12008/16435": No such file or
directory

Now if the tablespace contains *only* unlogged tables, it should at
least theoretically be possible to recover from this situation on
startup, I think. But it's not now. Anybody have an idea about how
much work that would be?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Magnus Hagander 2011-05-03 18:45:56 Re: Unlogged vs. In-Memory
Previous Message Joshua Kramer 2011-05-03 18:28:27 Re: Unlogged vs. In-Memory

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2011-05-03 18:45:56 Re: Unlogged vs. In-Memory
Previous Message Tom Lane 2011-05-03 18:41:27 Re: Prefered Types