From: Nimesh Satam <nimesh.zedo@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: pgsql-performance@postgresql.org
Cc: database@zedo.com
Subject: Re: pg_statistic doesnt contain details for specific table
Date: Mon, 11 Jun 2007 19:22:24 +0530
Message-ID: <965aa3ed0706110652k496af68di8217d488fa6e297a@mail.gmail.com> (raw)
In-Reply-To: <20070611132953.GA32879@winnie.fuhr.org>
References: <965aa3ed0706110150g6f5e85bevfb4be0b50b649271@mail.gmail.com>
<466D0DB4.2080404@enterprisedb.com>
<965aa3ed0706110158r27c9c19aj32a87d9ccf7e2383@mail.gmail.com>
<20070611132953.GA32879@winnie.fuhr.org>
Michael,
Following is the output of Vacuum analze on the same table:
*psql =# VACUUM ANALYZE verbose cam_attr;
INFO: vacuuming "public.cam_attr"
INFO: index "cam_attr_pk" now contains 11829 row versions in 63 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: "cam_attr": found 0 removable, 11829 nonremovable row versions in 103
pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 236 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.cam_attr"
INFO: "cam_attr": scanned 103 of 103 pages, containing 11829 live rows and
0 dead rows; 6000 rows in sample, 11829 estimated total rows
VACUUM
*
Also how do we check if the statistics are set to Zero for the table?
Regards,
Nimesh.
On 6/11/07, Michael Fuhr <mike@fuhr.org> wrote:
>
> On Mon, Jun 11, 2007 at 02:28:32PM +0530, Nimesh Satam wrote:
> > We have already used analyze command on the table.
> > We have also ran the vacuum analyze command.
> >
> > But they are not helping.
>
> Is there any data in the table? What does ANALYZE VERBOSE or VACUUM
> ANALYZE VERBOSE show for this table? Is there any chance that
> somebody set all of the columns' statistics targets to zero?
>
> --
> Michael Fuhr
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nimesh.zedo@gmail.com, mike@fuhr.org, heikki@enterprisedb.com, database@zedo.com
Subject: Re: pg_statistic doesnt contain details for specific table
In-Reply-To: <965aa3ed0706110652k496af68di8217d488fa6e297a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox