Postgres db is slow asfk
lasse
PROOP

2 years ago

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

55 Replies



lasse
PROOP

2 years ago

In this video i show how slow it is


lasse
PROOP

2 years ago

N/A


brody
EMPLOYEE

2 years ago

where are you located geographically compared to your database?


lasse
PROOP

2 years ago

in denmark and the its placed in the us i think


lasse
PROOP

2 years ago

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


brody
EMPLOYEE

2 years ago

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


lasse
PROOP

2 years ago

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


lasse
PROOP

2 years ago

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


lasse
PROOP

2 years ago

and i wanna use them before i upgrade to pro


brody
EMPLOYEE

2 years 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
PROOP

2 years ago

Yeah, what other regions does railway have?


brody
EMPLOYEE

2 years ago


lasse
PROOP

2 years ago

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


brody
EMPLOYEE

2 years ago

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


lasse
PROOP

2 years ago

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


brody
EMPLOYEE

2 years ago

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


lasse
PROOP

2 years ago

Okay thanks!


brody
EMPLOYEE

2 years 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
PROOP

2 years ago

Alright beacuse i got 100$ 💀

1232374508527161300


brody
EMPLOYEE

2 years ago

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


lasse
PROOP

2 years ago

Alright, it is on i need to do that?


brody
EMPLOYEE

2 years ago

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


brody
EMPLOYEE

2 years ago

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


lasse
PROOP

2 years ago

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


brody
EMPLOYEE

2 years ago

awesome, move that database over!


brody
EMPLOYEE

2 years ago

Amsterdam is quite close to Denmark so thats great


lasse
PROOP

2 years ago

Yeah, thanks again for your help!


brody
EMPLOYEE

2 years ago

no problem!


lasse
PROOP

2 years ago

@Brody much faster now!


brody
EMPLOYEE

2 years ago

awsome!


ob-vest
TRIAL

2 years ago

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


lasse
PROOP

2 years ago

kan du snakke dansk så?


ob-vest
TRIAL

2 years ago

Jeps


lasse
PROOP

2 years ago

Sådan


medim
MODERATOR

2 years 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
PROOP

2 years ago

ohh sorry.


ob-vest
TRIAL

2 years ago

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


lasse
PROOP

2 years ago

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


ob-vest
TRIAL

2 years ago

🇩🇰


ob-vest
TRIAL

2 years ago

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


lasse
PROOP

2 years ago

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


lasse
PROOP

2 years ago

1232610463703892000


brody
EMPLOYEE

2 years ago

yes


lasse
PROOP

2 years ago

Alright thanks!


lasse
PROOP

2 years 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"

lasse
PROOP

2 years ago

I'm testing with nixpacks locally


brody
EMPLOYEE

2 years ago

just a friendly reminder <#727685388893945877> #5


brody
EMPLOYEE

2 years ago

but yes, that does get nixpacks installing bun 1.1.4


lasse
PROOP

2 years ago

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

1234162818274824200


brody
EMPLOYEE

2 years ago

can you open a new thread for that


lasse
PROOP

2 years ago

Yes


brody
EMPLOYEE

2 years ago

there no need for pings


lasse
PROOP

2 years ago

You're right. But created the thread


Loading...