gkk
gkk
RRailway
Created by gkk on 11/9/2023 in #✋|help
Checking egress usage per-service
(which is very puzzling to me)
10 replies
RRailway
Created by gkk on 11/9/2023 in #✋|help
Checking egress usage per-service
it's the Postgres database
10 replies
RRailway
Created by gkk on 11/9/2023 in #✋|help
Checking egress usage per-service
Ah, I missed that button. Thanks!
10 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
my ultimate goal is to see whether I can host a db on railway for a Redwood.js app I'm working on. I'm currently on Render but have some perf issues of other sort and it's a deep rabbit hole. that's the whole story
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
to my surprise, postgres on railway doesn't pick up an index I created. it does pick it up anywhere else I tried (Render.com, my own local setup, etc)
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
and what I'm trying to test is whether I can perform full-text search queries on one of the columns
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
10m records, 2,5GB data dump in .sql format
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
I'm storing around 10m records in a single table. it's a fairly simple data
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
here's my email: [email protected]
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
credits sound good, I'm a paying user already
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
so getting to the same state might take a while, i will see if I can find another solution
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
this db took a while to set up as i was debugging those index issues
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
yep 😦
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
i see it restarted
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
?
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
i also don't see decreased RAM consumption
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
are you sure it did restart?
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
The restart didn't help with this error:
railway=# VACUUM "ImagePrompt";
ERROR: could not resize shared memory segment "/PostgreSQL.331712056" to 599519776 bytes: No space left on device
railway=# VACUUM "ImagePrompt";
ERROR: could not resize shared memory segment "/PostgreSQL.331712056" to 599519776 bytes: No space left on device
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
Is restarting coming on soon? I'm trying to debug some odd problem with postgres@railway not using an index. The identical query on identical db works like a charm on my local postgres install
49 replies
RRailway
Created by gkk on 10/20/2022 in #✋|help
Restart postgres
As a bit higher priority feature req. I wish all software was perfect, but we all know it isn't 🙂
49 replies