Very slow queries on Postgresql database

iruffeyi
PRO

11 days ago

I have already seen in other threads that it is a well-known problem that databases are sometimes very slow. We have had the same problems for some time now. Very simple queries often take 3-5 seconds and sometimes up to 12 seconds. I first thought it was due to our application, but I run simple UPDATE methods directly on the database and these also often take 3-10 seconds In some cases just around 50-100ms. I have the feeling that this is the case since we switched to Metal. Though I have a feeling it's only in the prod environment. I read that you can change it so that we can switch back to GCP and that works for others. Hence the question, does it work for us too? Is it then recommended to move all services from this project? 2 backends, redis, database and frontend?

Awaiting User Response

6 Replies

Railway
BOT

11 days ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!


11 days ago

I've enabled this for your workspace - and I would recommend moving all of your backend - frontend should be fine on metal unless you do server-to-server comms (then the GCP -> metal latency may be noticeable)


Status changed to Awaiting User Response Railway 11 days ago


iruffeyi
PRO

11 days ago

Thank you. At first glance it works and we haven't had a problem for the last half hour. Thanks for the quick help. Can you say how I can tell in the future that it is working again and we can move back to Metal?


Status changed to Awaiting Railway Response Railway 11 days ago


11 days ago

We'll reach out once we've fixed the metal issues


Status changed to Awaiting User Response Railway 11 days ago


winter100004
PRO

11 days ago

I also have such a problem in the production environment, which has a great impact


Status changed to Awaiting Railway Response Railway 11 days ago


winter100004

I also have such a problem in the production environment, which has a great impact

11 days ago

Heya, please open a thread for this


Status changed to Awaiting User Response Railway 11 days ago


Very slow queries on Postgresql database - Railway Help Station