Postgres DB eating too much RAM
I just got my monthly billing and it seemed too high, and my PG DB uses an average of 3GB of RAM. I thought my bill was a little hight before, but now it seems ludicrous. I have a couple of open connections to the database and my app use is close to none
12 Replies
Can you provide your project ID in this case?
For 3GB it should cost $30/mo-ish. Is that not what you're seeing?
Yes, it is what i am seeing. My point is that a barely used database definitely shouldn't use 3GB of RAM
e40da83a-cffa-4c89-a560-e1b51f20a45c@zikk did you get any solution mysql database started doing the same almost 3 GB and I barely use it
That seems quite odd.
I have a project with a Node server and a Postgres DB set up in a project, and for the past two months my bill hasn't exceeded $2.70.
Here is my project ID for reference should it help debugging - c06b06b6-884b-49b4-84e5-334eead0421c
Seems to be spoken about more in depth here.
https://discord.com/channels/713503345364697088/1015030824384614490
I have other project which is working the dame wat , but in this project MySQL keeps consuming more and more ram
mysql has always been memory intensive
but i dont even have more than 2000 records
TL'DR - MySQL is not great on Railway. We are working on fixing it.
Hey @Javier Fuentes Mora - just spoke with the team about this. We are annoyed with the RAM usage with MySQL too.
With that said, aside from closing connections, because we run DBs via images, DB GC collection is going to lead to elevated RAM usage on Docker. So thats what you are seeing. Its not your fault but we can do a better job managing this.
ohh ok
so should I move to
postgresql ?
and i guess this month im gonna have to paymore??
@Angelo
I would yes
And please don’t tag the team