Re: Need help understanding vacuum verbose output - Mailing list pgsql-general

From Gordon Shannon
Subject Re: Need help understanding vacuum verbose output
Date
Msg-id 1281111466190-2266825.post@n5.nabble.com
Whole thread Raw
In response to Re: Need help understanding vacuum verbose output  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Yes, and also from the original post:

> 3  INFO:  scanned index "authors_archive_pkey" to remove 45878 row
> versions
> 4  DETAIL:  CPU 0.05s/0.34u sec elapsed 0.41 sec.
> 5  INFO:  "authors_archive": removed 45878 row versions in 396 pages
> 6  DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.

Line 5 is talking about the relation, not the index, right?  Anyway, I know
it did remove 45878 row versions, cuz that's how many I deleted, and the
stats now say 0 dead tuples.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Need-help-understanding-vacuum-verbose-output-tp2265895p2266825.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Need help understanding vacuum verbose output
Next
From: Tom Lane
Date:
Subject: Re: Need help understanding vacuum verbose output