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;
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 |