Vacuum analyze question on estimated rows

From: "Sailer, Denis (YBUSA-CDR)" <Denis(dot)Sailer(at)Yellowbook(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum analyze question on estimated rows
Date: 2005-06-27 19:28:04
Message-ID: 3FB3AAE149F4AD4D8499E15EE8CF41A34603A7@YBCDREX01.corp.ybusa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In the following output the vacuum knows there are 99,612 pages and
1,303,891 rows. However the last line of output during the analyze only
thinks there are 213,627 rows. Is this so far off because the table is
bloated? Version of PostgreSQL is "PostgreSQL 7.4.3 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2"

INFO: vacuuming "ods.production_fact"

INFO: index "production_fact_pkey" now contains 1303891 row versions in
30843 pages

DETAIL: 0 index pages have been deleted, 0 are currently reusable.

CPU 3.21s/0.24u sec elapsed 58.51 sec.

INFO: "production_fact": found 0 removable, 1303891 nonremovable row
versions in 99612 pages

DETAIL: 0 dead row versions cannot be removed yet.

There were 12241393 unused item pointers.

0 pages are entirely empty.

CPU 7.33s/0.78u sec elapsed 64.37 sec.

INFO: vacuuming "pg_toast.pg_toast_104431207"

INFO: index "pg_toast_104431207_index" now contains 0 row versions in 1
pages

DETAIL: 0 index pages have been deleted, 0 are currently reusable.

CPU 0.00s/0.00u sec elapsed 0.18 sec.

INFO: "pg_toast_104431207": found 0 removable, 0 nonremovable row
versions in 0 pages

DETAIL: 0 dead row versions cannot be removed yet.

There were 0 unused item pointers.

0 pages are entirely empty.

CPU 0.00s/0.00u sec elapsed 0.37 sec.

INFO: analyzing "ods.production_fact"

INFO: "production_fact": 99612 pages, 3000 rows sampled, 213627
estimated total rows

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-06-27 19:43:57 Re: Populating huge tables each day
Previous Message Jeff Gold 2005-06-27 19:09:54 Re: Postmaster Out of Memory