postgres volume storage availabile not increasing when deleting rows in tables
Hi I am using n8n with railway, and it has Postgres attached, recently the Postgres volume was nearing it’s limit, so one of the tables had 70k + rows deleted.
After doing this, the Postgres volume never decreased active gb usage. So now I’m nearing my limit of available storage.
What can I do? Why is the volume not freeing up space?
5 Replies
Project ID:
4edc1a90-e5df-4c2f-affd-1f06796d04f2
Project id 4edc1a90-e5df-4c2f-affd-1f06796d04f2
run a vacuum?
@Brody I did run a vacuum. From what I'm reading a standard vacuum doesn't "free up space", you'd need to vacuum full.
But apparently the utilized space on a table is more permenantish and it will be reused.
Is that correct in railway?
Sorry new to postgres so might be not understanding some fundamental concepts
railways postgres database is just the postgres docker image nothing special going on