On Tue, 26 Dec 2006 18:12:45 +0100 Martijn van Oosterhout <kleptog@svana.org> wrote: > On Tue, Dec 26, 2006 at 12:04:40PM -0500, D'Arcy J.M. Cain wrote: > > Now it certainly seems to me that it should behave as described given > > the definition of VACUUM FULL so I am a little confused by my tests. > > My test table only has two entries in it. Is that the issue? In fact, > > I find the same behaviour if I do a simple VACUUM on the table. > > On a table with two entries, VACUUM FULL is going to do nothing of > interest. Moving tuples within a page is useless, generally.
I thought that that might be the issue. The docs should probably say "can" instead of "will" then. -- D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq