Semisol 👨💻 on Nostr: Tell me you don’t know how DBs work without telling me you don’t know how DBs ...
Tell me you don’t know how DBs work without telling me you don’t know how DBs work.
The dropped columns are deleted once a row containing the value is updated, or for the entire table once a full vacuum is ran.
After that the only thing that remains is the column having existed. Rewriting the entire table immediately on drop column would be disruptive (just do a vacuum if you care!), and removing the record of the column existing would require a similar operation that has negligible benefits
The dropped columns are deleted once a row containing the value is updated, or for the entire table once a full vacuum is ran.
After that the only thing that remains is the column having existed. Rewriting the entire table immediately on drop column would be disruptive (just do a vacuum if you care!), and removing the record of the column existing would require a similar operation that has negligible benefits
quoting note18gv…8etpFun fact. Postgres doesn't delete any columns, EVER. Not even full vacuum does it. They are all soft deleted.
In fact, if you modified your table so much that you run into the column limit, your only option is to create a new table and copy the data over there.
AWS and the NSA are loving this.