top | item 46699749 (no title) SigmundA | 1 month ago You mean tablespaces: https://www.postgresql.org/docs/current/manage-ag-tablespace... ? discuss order hn newest ComputerGuru|1 month ago Maybe? I wasn’t under the impression these could be reliably lost or out of sync without risking data loss? SigmundA|1 month ago Wasn't aware you could put a WAL on a unreliable storage system either without risking data loss?Would be interesting for indexes say put them on ram drive and rebuild them on restart if they aren't there just fallback to table scans.MSSQL has memory optimized tables that do this sort of thing: https://learn.microsoft.com/en-us/sql/relational-databases/i... load replies (1)
ComputerGuru|1 month ago Maybe? I wasn’t under the impression these could be reliably lost or out of sync without risking data loss? SigmundA|1 month ago Wasn't aware you could put a WAL on a unreliable storage system either without risking data loss?Would be interesting for indexes say put them on ram drive and rebuild them on restart if they aren't there just fallback to table scans.MSSQL has memory optimized tables that do this sort of thing: https://learn.microsoft.com/en-us/sql/relational-databases/i... load replies (1)
SigmundA|1 month ago Wasn't aware you could put a WAL on a unreliable storage system either without risking data loss?Would be interesting for indexes say put them on ram drive and rebuild them on restart if they aren't there just fallback to table scans.MSSQL has memory optimized tables that do this sort of thing: https://learn.microsoft.com/en-us/sql/relational-databases/i... load replies (1)
ComputerGuru|1 month ago
SigmundA|1 month ago
Would be interesting for indexes say put them on ram drive and rebuild them on restart if they aren't there just fallback to table scans.
MSSQL has memory optimized tables that do this sort of thing: https://learn.microsoft.com/en-us/sql/relational-databases/i...