Postgres db is slow asfk

a year ago

Anyone know why my postgres db takes around 3-4 seconds to find one row in my database.

0 Replies



a year ago

In this video i show how slow it is


a year ago

N/A


a year ago

where are you located geographically compared to your database?


a year ago

in denmark and the its placed in the us i think


a year ago

but i have once had an postgres before, also in the us. But then it was not this slow


a year ago

you're pro as far as I can tell, try moving your database closer


a year ago

I'm not on the pro plan anymore. I dont know why i have the role still


a year ago

but i can upgrade mabye, but its beacuse i have 100$ in credits.


a year ago

and i wanna use them before i upgrade to pro


a year 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


a year ago

Yeah, what other regions does railway have?


a year ago


a year ago

I see they have Amsterdam. Do i need to pay more than the 20$ for pro if i upgrade?


a year ago

$20 for the seat and then any additional resources you use


a year ago

Arr alright. And my credits will not work then ig?


a year ago

there's no extra costs for regions as all regions are available for pro users


a year ago

Okay thanks!


a year 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


a year ago

Alright beacuse i got 100$ 💀

1232374508527161300


a year ago

I can't see them having any issues doing that for you


a year ago

Alright, it is on i need to do that?


a year ago

yeah, but you'd first need to be on pro to open a private chat with the team


a year ago

of course also because you'd need a pro plan for them to have a place to move the credits to


a year ago

Yeah makes total sense, i'm on pro plan again now!


a year ago

awesome, move that database over!


a year ago

Amsterdam is quite close to Denmark so thats great


a year ago

Yeah, thanks again for your help!


a year ago

no problem!


a year ago

@Brody much faster now!


a year ago

awsome!


ob-vest
TRIAL

a year ago

Interesting. I also live in Denmark, but it isn't super slow for me.


a year ago

kan du snakke dansk så?


ob-vest
TRIAL

a year ago

Jeps


a year ago

Sådan


a year 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)


a year ago

ohh sorry.


ob-vest
TRIAL

a year ago

Did you just want to confirm whether I speak Danish 🤣 Or do you actually have a question?


a year ago

Just to confirm, its not every there is someone from same contry as me


ob-vest
TRIAL

a year ago

🇩🇰


ob-vest
TRIAL

a year ago

I do hope that railway listens to previous proposals about allowing users in the hobby plan to set a default region.


a year ago

@Brody The 20$ of the estimated bill also includes the member seat right?


a year ago

1232610463703892000


a year ago

yes


a year ago

Alright thanks!


a year ago

@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"

a year ago

I'm testing with nixpacks locally


a year ago

just a friendly reminder <#727685388893945877> #5


a year ago

but yes, that does get nixpacks installing bun 1.1.4


a year ago

ohh i'm so sorry. But it seems not to work ig

1234162818274824200


a year ago

can you open a new thread for that


a year ago

Yes


a year ago

there no need for pings


a year ago

You're right. But created the thread