3 ms·
That's not terribly uncommon. PostgreSQL also does not reclaim space from deleted rows until you vacuum. Many hash table implementations also only mark items
by kscaldef 16y ago
That's not terribly uncommon. PostgreSQL also does not reclaim space from deleted rows until you vacuum. Many hash table implementations also only mark items deleted rather than actually removing them.
- selenamarie 16y agoAlthough - for further clarification, PostgreSQL doesn't require 2x the total amount of disk to reclaim/reuse space under normal circumstances. As of version 8.1 (out since 2005), VACUUMing is an automatic function inside the server. (autovacuum)