Search Postgresql Archives

Re: Need help understanding vacuum verbose output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux