Is there any safe way to use ephemeral storage (deleted on halt) for postgresql cluster?

  • 1
    Yes. Don't halt the VM. – mustaccio Aug 22 '18 at 19:29
  • or only store data that's not important in the cluster – Jasen Aug 24 '18 at 6:04

Use it for system swap space. Swapping doesn't hurt performance, running out of memory hurts performance. swapping is just a symptom.

You could also try putting unlogged temporary tables there but I'm not sure what would happen when they disappear.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.