On Wed, Feb 21, 2018 at 5:09 PM, Peter Geoghegan <p...@bowt.ie> wrote:
> On Wed, Feb 21, 2018 at 12:07 PM, Claudio Freire <klaussfre...@gmail.com> 
> wrote:
>> On Wed, Feb 21, 2018 at 4:50 PM, Peter Geoghegan <p...@bowt.ie> wrote:
>>> On Wed, Feb 21, 2018 at 7:53 AM, Rick Otten <rottenwindf...@gmail.com> 
>>> wrote:
>>>> side note:  The disadvantage of local SSD is that it won't survive "hitting
>>>> the virtual power button" on an instance, nor can it migrate automatically
>>>> to other hardware.  (We have to hit the power button to add memory/cpu to
>>>> the system, and sometimes the power button might get hit by accident.)  
>>>> This
>>>> is OK for temp space.  I never have my database come up automatically on
>>>> boot, and I have scripted the entire setup of the temp space volume and 
>>>> data
>>>> structures.  I can run that script before starting the database.   I've 
>>>> done
>>>> some tests and it seems to work great.  I don't mind rolling back any
>>>> transaction that might be in play during a power failure.
>>> It sounds like you're treating a temp_tablespaces tablespace as
>>> ephemeral, which IIRC can have problems that an ephemeral
>>> stats_temp_directory does not have.
>> For instance?
>> I've been doing that for years without issue. If you're careful to
>> restore the skeleton directory structure at server boot up, I haven't
>> had any issues.
> Then you clearly know what I mean already. That's not documented as
> either required or safe anywhere.

Ah, ok.

But the OP did mention he was doing that already. So it should be safe.

Reply via email to