From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: VACUUM ANALYZE differs under 7.2.3 from 7.2.1 |
Date: | 2002-10-28 18:49:11 |
Message-ID: | 15795.1035830951@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jeff Boes <jboes(at)nexcerpt(dot)com> writes:
> 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.
Hard to believe ... I see no changes in the 7.2.* CVS logs that might
cause such a problem.
> 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.
Here I get zeroes, as you expect, with 7.2.3. Some problem with your
installation perhaps?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-10-28 23:44:09 | Bug #806: create function failing... ERROR: stat failed on file ' |
Previous Message | Mr Yves Crevecoeur | 2002-10-28 17:39:55 | Re: socket problem under BeOS |