DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=IFytXIxDfVtzKwK/zzDTq1rA8djW9wHaKBwRpwnQbLw03BPuQhvolQbxFlAmNBGHnkVESbLfoKuwivQyag6gXnEA/6YuwPnbYNNzxRUMZmDSXl9nr+WIRpXnGxYqFHq5YAe6dlxlFISQBC1ji3E4fwszIIjUkYwPwAsTbTRClk0=
Message-ID: <965aa3ed0706110652k496af68di8217d488fa6e297a@mail.gmail.com>
Date: Mon, 11 Jun 2007 19:22:24 +0530
From: "Nimesh Satam" <nimesh.zedo@gmail.com>
To: "Michael Fuhr" <mike@fuhr.org>
Subject: Re: pg_statistic doesnt contain details for specific table
Cc: "Heikki Linnakangas" <heikki@enterprisedb.com>,
	pgsql-performance@postgresql.org, database@zedo.com
In-Reply-To: <20070611132953.GA32879@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_75918_17637968.1181569944250"
References: <965aa3ed0706110150g6f5e85bevfb4be0b50b649271@mail.gmail.com>
	<466D0DB4.2080404@enterprisedb.com>
	<965aa3ed0706110158r27c9c19aj32a87d9ccf7e2383@mail.gmail.com>
	<20070611132953.GA32879@winnie.fuhr.org>

------=_Part_75918_17637968.1181569944250
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
>

------=_Part_75918_17637968.1181569944250
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Michael,</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Following is the output of Vacuum analze on the same table:</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><strong>psql =# VACUUM ANALYZE verbose cam_attr;<br>INFO:&nbsp; vacuuming &quot;public.cam_attr&quot;<br>INFO:&nbsp; index &quot;cam_attr_pk&quot; now contains 11829 row versions in 63 pages<br>DETAIL:&nbsp; 0 index pages have been deleted, 0 are currently reusable.
<br>CPU 0.00s/0.00u sec elapsed 0.00 sec.<br>INFO:&nbsp; &quot;cam_attr&quot;: found 0 removable, 11829 nonremovable row versions in 103 pages<br>DETAIL:&nbsp; 0 dead row versions cannot be removed yet.<br>There were 236 unused item pointers.
<br>0 pages are entirely empty.<br>CPU 0.00s/0.00u sec elapsed 0.00 sec.<br>INFO:&nbsp; analyzing &quot;public.cam_attr&quot;<br>INFO:&nbsp; &quot;cam_attr&quot;: scanned 103 of 103 pages, containing 11829 live rows and 0 dead rows; 6000 rows in sample, 11829 estimated total rows
<br>VACUUM<br></strong><br><br>Also how do we check if the statistics are set to Zero for the table?</div>
<div>&nbsp;</div>
<div>Regards,</div>
<div>Nimesh.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><span class="gmail_quote">On 6/11/07, <b class="gmail_sendername">Michael Fuhr</b> &lt;<a href="mailto:mike@fuhr.org">mike@fuhr.org</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On Mon, Jun 11, 2007 at 02:28:32PM +0530, Nimesh Satam wrote:<br>&gt; We have already used analyze command on the table.
<br>&gt; We have also ran the vacuum analyze command.<br>&gt;<br>&gt; But they are not helping.<br><br>Is there any data in the table?&nbsp;&nbsp;What does ANALYZE VERBOSE or VACUUM<br>ANALYZE VERBOSE show for this table?&nbsp;&nbsp;Is there any chance that
<br>somebody set all of the columns&#39; statistics targets to zero?<br><br>--<br>Michael Fuhr<br></blockquote></div><br>

------=_Part_75918_17637968.1181569944250--