Re: Possible documentation error

On Tue, Dec 26, 2006 at 06:12:45PM +0100, Martijn van Oosterhout 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.

A test on a larger table shows the behavior:

test=> CREATE TABLE foo (x integer);
CREATE TABLE
test=> INSERT INTO foo SELECT * FROM generate_series(1, 1000);
INSERT 0 1000
test=> DELETE FROM foo WHERE x BETWEEN 2 AND 999;
DELETE 998
test=> SELECT ctid, x FROM foo; ctid  |  x   
--------+------(0,1)  |    1(4,92) | 1000
(2 rows)

test=> VACUUM foo;
VACUUM
test=> SELECT ctid, x FROM foo; ctid  |  x   
--------+------(0,1)  |    1(4,92) | 1000
(2 rows)

test=> VACUUM FULL foo;
VACUUM
test=> SELECT ctid, x FROM foo;ctid  |  x   
-------+------(0,1) |    1(0,2) | 1000
(2 rows)

-- 
Michael Fuhr