Re: Adding a concept of TEMPORARY TABLESPACE for the use in temp_tablespaces - Mailing list pgsql-hackers

From Mitar
Subject Re: Adding a concept of TEMPORARY TABLESPACE for the use in temp_tablespaces
Date
Msg-id CAKLmikMmdyrEf2uG0_gSoKEuzd-b3bfEJwWEGWhiOwF2Of9L2A@mail.gmail.com
Whole thread Raw
In response to Re: Adding a concept of TEMPORARY TABLESPACE for the use intemp_tablespaces  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Adding a concept of TEMPORARY TABLESPACE for the use intemp_tablespaces
List pgsql-hackers
Hi!

On Fri, Jan 25, 2019 at 2:32 PM Bruce Momjian <bruce@momjian.us> wrote:
> I wrote a blog entry about this:
>
>         https://momjian.us/main/blogs/pgblog/2017.html#June_2_2017
>
> This is certainly an area we can improve, but it would require changes
> in several parts of the system to handle cases where the tablespace
> disappears.

Yes, I read the discussion thread you point at the end of your blog
post. [1] This is why I posted an e-mail to the mailing list because
some statements from that thread do not hold anymore. For example, in
the thread it is stated:

"Just pointing the tablespace to non'restart'safe storage will get you
an installation that fails to boot after a restart, since there's a
tree structure that is expected to survive, and when it's not found,
postgres just fails to boot."

This does not seem to be true (anymore?) based on my testing. You get
noise in logs, but installation boots without a problem.

So maybe we are closer to this than we realize?

[1] https://www.postgresql.org/message-id/flat/20170529185308.GB28209%40momjian.us


Mitar

-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m


pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: outdated reference to tuple header OIDs
Next
From: Evgeniy Efimkin
Date:
Subject: Re: Special role for subscriptions