Sample Header Ad - 728x90

Is postgres vacuum secure

2 votes
1 answer
306 views
Postgres delete doesn't actually remove the record from the table file. Once the delete is committed and the last transaction is closed, no postgres process can see the record any more, the deleted record is now liable to be vacuumed. Does vacuum (or some other system) overwrite the deleted data or is some of it left sitting in the table file? Obviously vacuum full and cluster will both re-write the files omitting the deleted record, but I'm particularly interested if there are any details about what ordinary vacuum will or, will not, do to fields stored in the heap and TOAST files.
Asked by Jasen (3656 rep)
Aug 9, 2018, 05:41 AM
Last activity: Aug 10, 2018, 12:06 AM