VACUUM ANALYZE differs under 7.2.3 from 7.2.1

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: VACUUM ANALYZE differs under 7.2.3 from 7.2.1
Date: 2002-10-24 16:51:45
Message-ID: 3DB82521.1070500@nexcerpt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The "VACUUM ANALYZE tablename" command does not have the same effect on
table metadata under 7.2.1 and 7.2.3. In particular, I've noted that
pg_class.reltuples is not updated by vacuuming after a delete.

Here is a sequence of SQL commands to demonstrate the difference. Under
7.2.1, the resulting last three displays of the pg_class.reltuples value
will be zero (0), while under 7.2.3 it will be 10.

create table foo (a char(1));

copy foo from stdin;

a

a

a

a

a

a

a

a

a

a

\.

\x

\t

select count(*) from foo;

select reltuples from pg_class where relname = 'foo';

vacuum foo;

select reltuples from pg_class where relname = 'foo';

vacuum analyze foo;

select reltuples from pg_class where relname = 'foo';

analyze foo;

select reltuples from pg_class where relname = 'foo';

delete from foo;

select reltuples from pg_class where relname = 'foo';

select count(*) from foo;

select reltuples from pg_class where relname = 'foo';

vacuum foo;

select reltuples from pg_class where relname = 'foo';

vacuum analyze foo;

select reltuples from pg_class where relname = 'foo';

analyze foo;

select reltuples from pg_class where relname = 'foo';

drop table foo;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-10-24 20:18:50 Re: Bug #805: pg_dump examines all tables even with -t "table_name" speficied
Previous Message Bruno Wolff III 2002-10-24 16:13:52 Re: set search_path documentation missing from development docs