Hello, I have a technical question about VACUUM
I assume all table data is kept in a single file and each index has its single file also. Also I assume that VACUUM cleans the file of 'dead pages' that consist of dead rows only. How does it manage to reduce file size without any locks ? Or which locks are applied ? -- Best regards, Ilia mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
