Steve Wampler <[EMAIL PROTECTED]> 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
vacuum verbose.

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to