No, you can use a memfd.

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