On Sat, Jan 22, 2005 at 12:13:00 +0900, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > Probably VACUUM works well for small to medium size tables, but not > for huge ones. I'm considering about to implement "on the spot > salvaging dead tuples".
You are probably vacuuming too often. You want to wait until a significant fraction of a large table is dead tuples before doing a vacuum. If you are scanning a large table and only marking a few tuples as deleted, you aren't getting much bang for your buck. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings