a month ago
I have found that the auto vacuum settings in Postgresql are quite underpowered and I'm seeing many slow queries until I manually vacuum the table.
I do not seem to be able to change the vacuum settings myself. Is there a way to do this?
2 Replies
a month ago
You can modify autovacuum settings using ALTER SYSTEM. Run commands like ALTER SYSTEM SET autovacuum_vacuum_scale_factor = '0.1'; for any vacuum parameters you want to tune, then execute SELECT pg_reload_conf(); to apply the changes. After that, restart your deployment using the 3-dot menu on your deployment. Railway's PostgreSQL databases are unmanaged, so you have full control over all configuration parameters including autovacuum_vacuum_threshold, autovacuum_analyze_threshold, vacuum_cost_delay, and any other standard PostgreSQL settings.
Status changed to Awaiting User Response Railway • about 1 month ago
a month ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • about 1 month ago
a month ago
This solution worked well. Thank you!
Status changed to Awaiting Railway Response Railway • about 1 month ago
Status changed to Solved brody • about 1 month ago