The file doesn’t have to be disk-backed.

Don't you need something mounted for that?

No, you can use a memfd.

And `/dev/shm/` (which postgres uses by default on most Unix platforms)