Re: having temp_tablespaces on less reliable storage

2025-07-11 Thread Ron Johnson
On Fri, Jul 11, 2025 at 10:46 AM Dimitrios Apostolou wrote: > > On Thu, 10 Jul 2025, Dimitrios Apostolou wrote: > > > Hello list, > > > > I have a database split across many tablespaces, with temp_tablespaces > > pointing to a separate, less reliable device (single local NVMe drive). > How > > da

Re: having temp_tablespaces on less reliable storage

2025-07-11 Thread Dimitrios Apostolou
On Thu, 10 Jul 2025, Dimitrios Apostolou wrote: Hello list, I have a database split across many tablespaces, with temp_tablespaces pointing to a separate, less reliable device (single local NVMe drive). How dangerous is it for the cluster to be unrecoverable after a crash? If the drive go

Re: having temp_tablespaces on less reliable storage

2025-07-10 Thread David G. Johnston
On Thu, Jul 10, 2025 at 10:58 AM Dimitrios Apostolou wrote: > Can't find any related documentation, but I expect loss of "temp" space is > of minor importance. > You might want to try finding some old discussions about why putting temp tablespace on a RAM-drive is not a supported configuration.