Postgres db is slow asfk
Anyone know why my postgres db takes around 3-4 seconds to find one row in my database.
45 Replies
Project ID:
N/AIn this video i show how slow it is
where are you located geographically compared to your database?
in denmark and the its placed in the us i think
but i have once had an postgres before, also in the us. But then it was not this slow
Solution
you're pro as far as I can tell, try moving your database closer
I'm not on the pro plan anymore. I dont know why i have the role still
but i can upgrade mabye, but its beacuse i have 100$ in credits.
and i wanna use them before i upgrade to pro
well Denmark is quite far away from us-west1 so the time you see makes total sense, databases are very susceptible to distance and rtt
Yeah, what other regions does railway have?
I see they have Amsterdam. Do i need to pay more than the 20$ for pro if i upgrade?
$20 for the seat and then any additional resources you use
Arr alright. And my credits will not work then ig?
there's no extra costs for regions as all regions are available for pro users
Okay thanks!
you'd need to open a thread and ask the team to move them over once you have already signed up for a pro plan
Alright beacuse i got 100$ 💀
I can't see them having any issues doing that for you
yeah, but you'd first need to be on pro to open a private chat with the team
of course also because you'd need a pro plan for them to have a place to move the credits to
Yeah makes total sense, i'm on pro plan again now!
awesome, move that database over!
Amsterdam is quite close to Denmark so thats great
Yeah, thanks again for your help!
no problem!
@Brody much faster now!
awsome!
Interesting. I also live in Denmark, but it isn't super slow for me.
kan du snakke dansk så?
Jeps
SÃ¥dan
(try to maintain the convo in english guys, so if someone has the same issue he can try to guide himself through this thread)
ohh sorry.
Did you just want to confirm whether I speak Danish 🤣 Or do you actually have a question?
Just to confirm, its not every there is someone from same contry as me
🇩🇰
I do hope that railway listens to previous proposals about allowing users in the hobby plan to set a default region.
@Brody The 20$ of the estimated bill also includes the member seat right?
yes
Alright thanks!
@Brody I got a question nixpacks with bun. Would this work?
I'm testing with nixpacks locally
just a friendly reminder #🛂｜readme #5
but yes, that does get nixpacks installing bun 1.1.4
ohh i'm so sorry. But it seems not to work ig
can you open a new thread for that
Yes
there no need for pings
You're right. But created the thread