Is it possible to increase Postgres instance memory or volume size?

I saw this error for the first time today pq: could not resize shared memory segment "/PostgreSQL.1910953054" to 2097152 bytes: No space left on device. My app uses Redis and applies heavy caching, but there are enough requests that I think Postgres is starting to hiccup. I'm on a hobby plan. The disk size is still sufficient, I'm at like 2GB of 5GB but I think the Postgres DB is using a bit of memory
No description
13 Replies
Percy
Percy10mo ago
Project ID: 2cd73526-5a1f-4dd1-9e3a-a7de9a5290ab
cybershizo
cybershizo10mo ago
Railway
404 - Page not found
Railway is an infrastructure platform where you can provision infrastructure, develop with that infrastructure locally, and then deploy to the cloud.
cybershizo
cybershizo10mo ago
Does upgrading to a Team plan automatically fix these issues?
Brody
Brody10mo ago
hobby gets you a 5gb volume and it's entirely possible that postgres is trying to allocate some space that isn't available. you can upgrade to pro, then after you move your project to the team workspace go into the postgres volumes settings and grow the volume to 50gb
cybershizo
cybershizo10mo ago
Thanks. What about RAM? Also what happens if you use >50 GB?
Brody
Brody10mo ago
I think you're getting ram and volume terminology mixed up, ram is memory and volume is storage, the data in postgres is stored in the volume. once on the team and you find yourself needing more of anything you would need to email the team for a custom plan
cybershizo
cybershizo10mo ago
@Brody No I know my point was I can't see how much memory is available to me here
No description
cybershizo
cybershizo10mo ago
I don't know what the RAM limits are or how to find them
Brody
Brody10mo ago
hobby: 8gb pro 32gb that graph auto scales
cybershizo
cybershizo10mo ago
Oh thanks, OK 8GB is plenty. It's per instance?
Brody
Brody10mo ago
correct, per service
cybershizo
cybershizo10mo ago
Thanks!
Brody
Brody10mo ago
no problem!
Want results from more Discord servers?
Add your server