Vitor Pamplona on Nostr: Fun fact. Postgres doesn't delete any columns, EVER. Not even full vacuum does it. ...
Fun 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.
Published at
2025-04-23 23:18:00Event JSON
{
"id": "3a1980ac7ca29a94665e2dae8185c935e4d242950746c511569d2b0579d6bbda",
"pubkey": "460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"created_at": 1745450280,
"kind": 1,
"tags": [
[
"alt",
"A short note: Fun fact. Postgres doesn't delete any columns, EVE..."
]
],
"content": "Fun fact. Postgres doesn't delete any columns, EVER. Not even full vacuum does it. They are all soft deleted.\n\nIn 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. \n\nAWS and the NSA are loving this.",
"sig": "c627ef0f988c5d086ee80fbab82ceb6e2c17d9fc143af937661daf23f56ff8d1e13846fe6a655b02ac1b7f2722822a29445bc91f9a94322378145b12829481b7"
}
