Steve Wampler <swampler(at)noao(dot)edu> writes:
> Thanks, Tom. Are there any reasons why it would not appear?:
Oh, I shoulda read the code more carefully. I was looking at the bottom
of lazy_scan_index, where the printout is done, and failed to notice the
test at the top:
* If the index is not partial, skip the scan, and just assume it has
* the same number of tuples as the heap.
So for ordinary indexes, nothing will appear unless vacuum has actual
work to do (that is, it recycled at least one dead tuple in the table).
Short answer: update or delete some row in the table, and then try
Alternatively, you can just look at the pg_class row for the index.
relpages and reltuples will contain the info you are after ... and
they are certainly up to date at this point ;-)
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Jack Coates||Date: 2003-12-08 17:43:45|
|Subject: Re: tuning questions|
|Previous:||From: Steve Wampler||Date: 2003-12-08 15:14:53|
|Subject: Re: Help tracking down problem with inserts slowing|