I am trying to launch a small Phoenix application with postgres. However, the db instance keep crashing because out-of-memory.
When building my app it is too expensive to go directly to the Production level. And the Development level is just to “small”.
Alternatively, allow two options for Development, similar as there are two options for Production.
I think this would be great for newcomers to fly.io that want to have a successful start to the amazing platform.
Mail from fly
—8<----------------
Hello! Your “drishti-db” application hosted on Fly.io crashed because it ran out of memory. Specifically, the instance <>. Adding more RAM to your application might help!
You should know that adding RAM does cost money. Not much, but some. Figure about $5/mo per extra GB. Our docs have complete pricing details.
When you’re ready, add more RAM by running this from the command line:
fly machine update [machineID] --vm-memory [memoryMB] --app drishti-db
Replace [machineID] and [memoryMB] with the machine ID and the amount of memory you want to use, in megabytes eg. 2048.
You may also need to update your Postgres config in order to take advantage of the additional memory. For more information, check out the Scale Postgres VMs docs.
Here’s the raw log message:
Out of memory: Killed process 911 (postgres) total-vm:119832kB, anon-rss:4120kB, file-rss:0kB, shmem-rss:6860kB, UID:102 pgtables:180kB oom_score_adj:0
—8<----------------
