Restart Postgres due to slow response
My postgres instance is all the sudden seems to be lagging, starting around 03/29 19:02:30 CST. Is there any where to restart the instance?
17 Replies
project id: e4df9946-38db-45e6-89d8-8f73be4f0b4a
plugin id: a45c8746-33c0-4b92-a75b-b1ea09c2db80
yes, do /beta here then you will have access to the database restart in your command pallet
@Brody What is the name of the command? I verified I have beta access in the "Account Settings" but I'm not seeing anything that would indicate a restart
#🛂｜readme #5
My apologies!
it's just called restart
or restart plugin
well you would need to have the plugin open lol
Omg... 
I was able to restart, my postgres instance still is lagging super hard, not entirely sure why. Metrics are low, 2% CPU avg over past day, mem ~200-400mb, so nothing crazy there.
But doing the most simple query
I was able to restart, my postgres instance still is lagging super hard, not entirely sure why. Metrics are low, 2% CPU avg over past day, mem ~200-400mb, so nothing crazy there.
But doing the most simple query SELECT now() can take multiple secondsyeah the database experience with railway isnt great at the moment
Flagging this thread. A team member will be with you shortly.
yeah the database experience with railway isnt great at the momentNot to grave dig, but did you mean at the current moment (as in that night) db exp on railway isn't great, or overall it isn't great, withimprovements (hopefully) down the road. It looked like the latency lasted about 4 hours and then resolved. I also didn't notice anyone else mentioning it / reported on the status pages. I have since moved my db back to the previous hosting company but would prefer to move it back to railway assuming it's a rare occurrence.
i love railway to death, but yes overall database experience is not great (unstable, at least postgre and mysql), and im sorry to say this, but you would be better off keeping your data with your previous database provider, or moving it to something like Neon
but railway does have plans to fix database issues, but until then i cant recommend databases with railway, see most recent example:
https://discord.com/channels/713503345364697088/1091408310269386853
Appreciate the honest answer! I look forward to the updates down the road
i do too
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
can you guys upgrade mongodb version ??