OK to put temp tablespace on volatile storage or to omit it from backups?

Поиск
Список
Период
Сортировка
От Yang Zhang
Тема OK to put temp tablespace on volatile storage or to omit it from backups?
Дата
Msg-id CAKxBDU_Rkb2vOFaj1bGNHYHg0JPOZnM_bWUOOnX9_cHzhR5E9w@mail.gmail.com
обсуждение исходный текст
Ответы Re: OK to put temp tablespace on volatile storage or to omit it from backups?  (Darren Duncan <darren@darrenduncan.net>)
Re: OK to put temp tablespace on volatile storage or to omit it from backups?  (Julian Glass <tempura@internode.on.net>)
Список pgsql-general
Дерево обсуждения 
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:

If I were to lose my temp tablespace upon system crash, would this
prevent proper crash recovery?

Also, if I were to omit the temp tablespace from the base backup,
would that prevent proper backup recovery?

Thanks.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Simple SQL INSERT to avoid duplication failed: why?
Следующее
От: Darren Duncan
Дата:
Сообщение: Re: OK to put temp tablespace on volatile storage or to omit it from backups?