Bhanu Teja P
ERROR: could not resize shared memory segment "/PostgreSQL.1432368484" to 12615680 bytes:
Hi,
I am using Postgres database in Railway and I am getting this error. Can someone please help me figure out why this is happening? All of the solutions I see online tells me to change
shm_size of the database. But I don't think there is a way to change shm_size in Railway.
This is only happening for some of the complex or large queries that returns a lot of rows. How to fix this? What can I do to solve this?
Project ID: ef4b4933-5e06-4f9f-93d1-1153cb313e98
Some of the errors I am seeing are these:
ERROR: could not resize shared memory segment "/PostgreSQL.1432368484" to 12615680 bytes: No space left on device
FATAL: terminating background worker "parallel worker" due to administrator command
ERROR: could not resize shared memory segment "/PostgreSQL.1662690888" to 12615680 bytes: No space left on device
background worker "parallel worker" (PID 35856) exited with exit code 1
My usage dashboard says Your plan includes up to 8 GB of RAM, 8 vCPU, and 100 GB of Shared Disk. Manage your Plan.
and I am no where near those limits.81 replies