On Tue, Dec 26, 2006 at 12:49:55PM -0500, D'Arcy J.M. Cain wrote:
> 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.
The doumenttion is accurate as is. It says when "moved by VACUUM FULL".
In your case they wern't moved. If you change the word "will" to "can",
it will be wrong.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.