I created an app with a PostgreSQL database following these instructions. Unfortunately, the database gets OOM errors and is shut down if I attempt to perform writes to it. Documentation elsewhere appears to show that it’s possible to create shared CPU databases with 2GB memory, but the CLI only allows creation of shared CPU databases with 256MB.
Am I doing something wrong that the 256MB database app is immediately being OOMed?
Is there a way to create 2GB shared CPU databases?
I’m just setting up a standard Phoenix 1.6 application and the database immediately is using about 214MB of memory. I just remembered, however, that I have the ecto_psql_extras Hex package installed, as well as the pg_stat_statements PostgreSQL extension enabled, so perhaps it’s one of those driving up memory usage over what the tutorial expects.
I’m writing a single row with an email and a password, so these are very low-cost queries. It OOMed on the first write I sent.