Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 254B39FB789
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 11 Jun 2007 05:58:37 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 94959-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 11 Jun 2007 05:58:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.226])
	by postgresql.org (Postfix) with ESMTP id 390069FB664
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jun 2007 05:58:33 -0300 (ADT)
Received: by wx-out-0506.google.com with SMTP id s16so1299982wxc
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jun 2007 01:58:32 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=dz/h9/1Bx7HfaO53xB1ld1jhU5D8u3SbuQstM0DMI3TZpn42ZuT/gQC/IWC37xX+vZ7iUlFKIEHdSfamDxMGR/fzcmpjJZDfO4Sdi3acjhKuB1TxXn7Rk96Pk4goBzIxOyPzZqW2PP+Di5u9AC6J+THl8mdDj9RTTiD/VTOLzq4=
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=t01wEJ1hBz27otFP9QrOWk2Q0EXxXbmdAJPJf8h6+eu6cLM64XTffwu0UZ+Z8CFEa9AAZW0q5wf+b9lSqS9t0FKDKVqLRC0J/PjgPSRkHB0vWlK77rMbZHeH6tJaQpaw2paaJiJHNHYTnfNzaLEyfNnzx64knvGc/+ynCzo3jrI=
Received: by 10.70.39.2 with SMTP id m2mr6642367wxm.1181552312077;
	Mon, 11 Jun 2007 01:58:32 -0700 (PDT)
Received: by 10.70.118.16 with HTTP; Mon, 11 Jun 2007 01:58:32 -0700 (PDT)
Message-ID: <965aa3ed0706110158r27c9c19aj32a87d9ccf7e2383@mail.gmail.com>
Date: Mon, 11 Jun 2007 14:28:32 +0530
From: "Nimesh Satam" <nimesh.zedo@gmail.com>
To: "Heikki Linnakangas" <heikki@enterprisedb.com>
Subject: Re: pg_statistic doesnt contain details for specific table
Cc: pgsql-performance@postgresql.org, database@zedo.com
In-Reply-To: <466D0DB4.2080404@enterprisedb.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_72609_3790621.1181552312040"
References: <965aa3ed0706110150g6f5e85bevfb4be0b50b649271@mail.gmail.com>
	<466D0DB4.2080404@enterprisedb.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/177
X-Sequence-Number: 25210

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

Heikki,


Thank you for replying.

We have already used analyze command on the table.
We have also ran the vacuum analyze command.


But they are not helping.

Thanks,
Nimesh.


On 6/11/07, Heikki Linnakangas <heikki@enterprisedb.com> wrote:
>
> Nimesh Satam wrote:
> > While monitioring we noticed that there are no details in the
> pg_statistics
> > for a particular table. Can you let us know what might be the reason?
> Also
> > what steps can be taken care for adding the statistics?
>
> Have you ANALYZEd the table?
>
> --
>   Heikki Linnakangas
>   EnterpriseDB   http://www.enterprisedb.com
>

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

<div>Heikki,</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Thank you for replying. </div>
<div>&nbsp;</div>
<div>We have already used analyze command on the table.</div>
<div>We have also ran the vacuum analyze command.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>But they are not helping.</div>
<div>&nbsp;</div>
<div>Thanks,</div><span class="sg">
<div>Nimesh.</div></span><br><br>
<div><span class="gmail_quote">On 6/11/07, <b class="gmail_sendername">Heikki Linnakangas</b> &lt;<a href="mailto:heikki@enterprisedb.com">heikki@enterprisedb.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Nimesh Satam wrote:<br>&gt; While monitioring we noticed that there are no details in the pg_statistics<br>
&gt; for a particular table. Can you let us know what might be the reason? Also<br>&gt; what steps can be taken care for adding the statistics?<br><br>Have you ANALYZEd the table?<br><br>--<br>&nbsp;&nbsp;Heikki Linnakangas<br>&nbsp;&nbsp;EnterpriseDB&nbsp;&nbsp; 
<a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br></blockquote></div><br>

------=_Part_72609_3790621.1181552312040--