Very slow queries on Postgresql database
iruffeyi
PROOP

5 months 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?

Solved

6 Replies

Railway
BOT

5 months 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!


itsrems
EMPLOYEE

5 months 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 5 months ago


iruffeyi
PROOP

5 months 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 5 months ago


itsrems
EMPLOYEE

5 months ago

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


Status changed to Awaiting User Response Railway 5 months ago


winter100004
PRO

5 months ago

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


Status changed to Awaiting Railway Response Railway 5 months ago


winter100004

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

itsrems
EMPLOYEE

5 months ago

Heya, please open a thread for this


Status changed to Awaiting User Response Railway 5 months ago


Railway
BOT

4 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 4 months ago


Loading...