Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id A81319FBAC2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 14 May 2007 13:17:00 -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 98341-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 14 May 2007 13:16:56 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.249])
	by postgresql.org (Postfix) with ESMTP id 759249FBABD
	for <pgsql-performance@postgresql.org>;
	Mon, 14 May 2007 13:16:56 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id d17so424218and
	for <pgsql-performance@postgresql.org>;
	Mon, 14 May 2007 09:16:55 -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=VumWvMaD/D4J76h6xjVixoXyxw8RODnV5oPgv1zd/2rp003RjNfer2jrbH+UemkvIOgUAebA2X+peKgPf8d3mNDbOUzf+mNrL72+bYf4ItuOZERbeHzYEV5Sntn0J9dkYzhtvUW4zEeMVtSgRcviG3jWQpSd2AxsceKO5VlDAdM=
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=tGt6xt2HvJjOwLGXXlqBsOeL9Ud4Y4e3t3N4BqMwh30qUs7aIdLE+av0twOYV4+K9W2QTu7mDF57MJq89K82BaQ5vYGcNf/CRNsyEN7/OO+mpfQQ1AaA1k4zebP6pDTlBjTHnRELaTcNPfXufIjwwx4DloGeIcjYMCxhahoEMEY=
Received: by 10.100.240.19 with SMTP id n19mr4633138anh.1179159415136;
	Mon, 14 May 2007 09:16:55 -0700 (PDT)
Received: by 10.100.6.20 with HTTP; Mon, 14 May 2007 09:16:54 -0700 (PDT)
Message-ID: <b09064f30705140916o7c1d1a24h2bdabd3714df2187@mail.gmail.com>
Date: Mon, 14 May 2007 09:16:54 -0700
From: "Y Sidhu" <ysidhu@gmail.com>
To: "Shoaib Mir" <shoaibmir@gmail.com>
Subject: Re: pg_stats how-to?
Cc: pgsql-performance@postgresql.org
In-Reply-To: <bf54be870705131751g32e29447l4ec3a2bfabca10e6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2584_11813423.1179159414977"
References: <4647B0A9.7080304@gmail.com>
	<bf54be870705131751g32e29447l4ec3a2bfabca10e6@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/250
X-Sequence-Number: 24640

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

I am trying to use them. I have set these values in my conf file:
  stats_start_collector TRUE  stats_reset_on_server_start FALSE
stats_command_string TRUE
now what?

Yudhvir
==========

On 5/13/07, Shoaib Mir <shoaibmir@gmail.com> wrote:
>
> Can you be a little more specific? What exactly are you trying to achieve
> with pg_stats?
>
> You can always get help for documentation at --> http://www.postgresql.org/docs/8.2/static/view-pg-stats.html
>
>
> --
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 5/13/07, Yudhvir Singh Sidhu < ysidhu@gmail.com> wrote:
> >
> > Anyone know of a pg_stats howto? I'd appreciate any direction.
> >
> > Yudhvir
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
>
>


-- 
Yudhvir Singh Sidhu
408 375 3134 cell

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

I am trying to use them. I have set these values in my conf file:<br>

 
<table style="border-collapse: collapse; width: 239pt;" border="0" cellpadding="0" cellspacing="0" width="319">
<col style="width: 125pt;" width="167">
 <col style="width: 114pt;" width="152">
 <tbody><tr style="height: 12.75pt;" height="17">
  <td class="xl24" style="height: 12.75pt; width: 125pt;" height="17" width="167">stats_start_collector</td>
  <td style="width: 114pt;" align="center" width="152">TRUE</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td class="xl24" style="height: 12.75pt;" height="17">stats_reset_on_server_start</td>
  <td align="center">FALSE</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td class="xl24" style="height: 12.75pt;" height="17">stats_command_string</td>
  <td align="center">TRUE</td>
 </tr></tbody>
</table>
<br>
now what?<br>
<br>
Yudhvir<br>
==========<br><br><div><span class="gmail_quote">On 5/13/07, <b class="gmail_sendername">Shoaib Mir</b> &lt;<a href="mailto:shoaibmir@gmail.com">shoaibmir@gmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Can you be a little more specific? What exactly are you trying to achieve with pg_stats?<br><br>You can always get help for documentation at --&gt; <a href="http://www.postgresql.org/docs/8.2/static/view-pg-stats.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.postgresql.org/docs/8.2/static/view-pg-stats.html
</a><br><br>--<br>Shoaib Mir<br>EnterpriseDB (<a href="http://www.enterprisedb.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.enterprisedb.com</a>)<br><br><div><span class="q"><span class="gmail_quote">
On 5/13/07, <b class="gmail_sendername">Yudhvir Singh Sidhu</b> &lt;<a href="mailto:ysidhu@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
ysidhu@gmail.com</a>&gt; wrote:</span></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><span class="q">Anyone know of a pg_stats howto? I&#39;d appreciate any direction.
<br><br>Yudhvir<br><br></span>---------------------------(end of broadcast)---------------------------<br>TIP 1: if posting/reading through Usenet, please send an appropriate<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; subscribe-nomail command to <a href="mailto:majordomo@postgresql.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">

majordomo@postgresql.org</a> so that your<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; message can get through to the mailing list cleanly<br></blockquote></div><br>
</blockquote></div><br><br clear="all"><br>-- <br>Yudhvir Singh Sidhu<br>408 375 3134 cell

------=_Part_2584_11813423.1179159414977--