| 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: | Whole Thread | Raw Message | 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 |