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
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 |