Restart postgres
Is there a way to restart postgres? Metrics is showing me that it's consuming 5GB of RAM which doesn't sound right.
Also, I'm getting this error:
My project id is 74efd967-91bd-4f9f-b792-2132571bf881
26 Replies
Hey @gkk,
Not yet, but I just restarted it for you.
Keep in mind, Postgres is going to try it's best to cache and take up all the ram availible for it so hence why you may see RAM creep.
That's a little aside, but Railway charing for RAM usage and not exposing any way to cap cache size (or VM size) is not a great combo.
And thanks for the quick reply!
We have knobs coming out for this so you can specifiy this upfront.
No timeline but this is just a quick way of saying... we know ;-;
Besides it helps us out too with resource planning on what box to send your DB to.
Got it. Looking forward to seeing this db restarted. I'd vote for
restart being available to users.That will come out sooner, lemme bug the other engs and see how quickly we can enable that.
As a bit higher priority feature req. I wish all software was perfect, but we all know it isn't π
you and me both
Is restarting coming on soon? I'm trying to debug some odd problem with postgres@railway not using an index. The identical query on identical db works like a charm on my local postgres install
Should be restarted, can you make a request to the DB?
I am looking at the logs.
The restart didn't help with this error:
are you sure it did restart?
i also don't see decreased RAM consumption
Maybe not from my GUI, jumping in the box right now.
?
Okay, confirmed restarted
No errors yet, can ya try now?
Anyways, unfortunately I need to jump on other cases. Let me know if its all working and I will try to help as much as I can
i see it restarted
damn:
yep π¦
Flagging to the team but not much else I can do here
If the data is not super important, you can tear this DB down and try anew. But going to have the team investigate this anyway if we can.
this db took a while to set up as i was debugging those index issues
so getting to the same state might take a while, i will see if I can find another solution
Gotcha, I am willing to give ya credits so we can keep that DB up while we dig into the state of things
Can you explain more about your setup, I think its running into daemon issues but wanna know more about what you are attempting to store
Railway email?
(or link account)
credits sound good, I'm a paying user already
here's my email: [email protected]
I'm storing around 10m records in a single table. it's a fairly simple data
10mb*
or 10 million
10m records, 2,5GB data dump in .sql format
Gotcha, okay, so the swap maybe is whats killing you
but it shouldn't do that
Okay, credits sent, going to dig in once we have a spare cycle
and what I'm trying to test is whether I can perform full-text search queries on one of the columns
to my surprise, postgres on railway doesn't pick up an index I created. it does pick it up anywhere else I tried (Render.com, my own local setup, etc)
my ultimate goal is to see whether I can host a db on railway for a Redwood.js app I'm working on. I'm currently on Render but have some perf issues of other sort and it's a deep rabbit hole. that's the whole story
Admittedly our DB story isn't the best, but this will help us finally fix this issue once and for all.
Unknown Userβ’2y ago
Message Not Public
Sign In & Join Server To View