R
Railway2mo ago
lasse

Postgres db is slow asfk

Anyone know why my postgres db takes around 3-4 seconds to find one row in my database.
Solution:
you're pro as far as I can tell, try moving your database closer
Jump to solution
45 Replies
Percy
Percy2mo ago
Project ID: N/A
lasse
lasse2mo ago
lasse
lasse2mo ago
In this video i show how slow it is
Brody
Brody2mo ago
where are you located geographically compared to your database?
lasse
lasse2mo ago
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
Brody
Brody2mo ago
you're pro as far as I can tell, try moving your database closer
lasse
lasse2mo ago
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
Brody
Brody2mo ago
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
lasse
lasse2mo ago
Yeah, what other regions does railway have?
lasse
lasse2mo ago
I see they have Amsterdam. Do i need to pay more than the 20$ for pro if i upgrade?
Brody
Brody2mo ago
$20 for the seat and then any additional resources you use
lasse
lasse2mo ago
Arr alright. And my credits will not work then ig?
Brody
Brody2mo ago
there's no extra costs for regions as all regions are available for pro users
lasse
lasse2mo ago
Okay thanks!
Brody
Brody2mo ago
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
lasse
lasse2mo ago
Alright beacuse i got 100$ 💀
No description
Brody
Brody2mo ago
I can't see them having any issues doing that for you
lasse
lasse2mo ago
Alright, it is on https://help.railway.app i need to do that?
Brody
Brody2mo ago
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
lasse
lasse2mo ago
Yeah makes total sense, i'm on pro plan again now!
Brody
Brody2mo ago
awesome, move that database over! Amsterdam is quite close to Denmark so thats great
lasse
lasse2mo ago
Yeah, thanks again for your help!
Brody
Brody2mo ago
no problem!
lasse
lasse2mo ago
@Brody much faster now!
Brody
Brody2mo ago
awsome!
kindred
kindred2mo ago
Interesting. I also live in Denmark, but it isn't super slow for me.
lasse
lasse2mo ago
kan du snakke dansk så?
kindred
kindred2mo ago
Jeps
lasse
lasse2mo ago
Sådan
Medim
Medim2mo ago
(try to maintain the convo in english guys, so if someone has the same issue he can try to guide himself through this thread)
lasse
lasse2mo ago
ohh sorry.
kindred
kindred2mo ago
Did you just want to confirm whether I speak Danish 🤣 Or do you actually have a question?
lasse
lasse2mo ago
Just to confirm, its not every there is someone from same contry as me
kindred
kindred2mo ago
🇩🇰 I do hope that railway listens to previous proposals about allowing users in the hobby plan to set a default region.
lasse
lasse2mo ago
@Brody The 20$ of the estimated bill also includes the member seat right?
lasse
lasse2mo ago
No description
Brody
Brody2mo ago
yes
lasse
lasse2mo ago
Alright thanks! @Brody I got a question nixpacks with bun. Would this work?
# nixpacks.toml
[phases.setup]
nixpkgsArchive = 'd05592ea7e9656648093dfe0e817819486bd5054'

[start]
cmd = "bunx prisma migrate deploy && bunx prisma generate && bun run start"
# nixpacks.toml
[phases.setup]
nixpkgsArchive = 'd05592ea7e9656648093dfe0e817819486bd5054'

[start]
cmd = "bunx prisma migrate deploy && bunx prisma generate && bun run start"
I'm testing with nixpacks locally
Brody
Brody2mo ago
just a friendly reminder #🛂|readme #5 but yes, that does get nixpacks installing bun 1.1.4
lasse
lasse2mo ago
ohh i'm so sorry. But it seems not to work ig
No description
Brody
Brody2mo ago
can you open a new thread for that
lasse
lasse2mo ago
Yes
Brody
Brody2mo ago
there no need for pings
lasse
lasse2mo ago
You're right. But created the thread