Screenshots

The error is about shared memory, not disk space actually*

We're hitting a wall with our Postgres database in production. Getting this error when running complex queries:

ERROR: could not resize shared memory segment "/PostgreSQL.361173462" to 4194304 bytes: No space left on device

Did some digging and found out our /dev/shm is only 62MB, which isn't enough for PostgreSQL's parallel workers. We've got about 37 active connections and when Postgres tries to spin up parallel workers for bigger queries, it just dies.

Is there any way to bump up the shared memory limit? Even getting it to 512MB would be huge. This is hitting us pretty hard in production right now, so any help would be amazing. Happy to provide more details or try any workarounds you might suggest.

Thanks!

am seeing the docs now, regarding this issue, apologies I missed it. https://docs.railway.com/guides/postgresql

All good! The issue with our Postgres that throws people off is that, it's not managed, however, it's so easy to deploy Postgres on Railway, people think that it is!

I am happy that you found a resolution to your problem. Here if you need any more help.

Thanks,
Angelo