Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 2AD7F2E2DEF
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  6 Mar 2008 02:31:13 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 10413-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  6 Mar 2008 02:31:08 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from ag-out-0708.google.com (ag-out-0708.google.com [72.14.246.248])
	by postgresql.org (Postfix) with ESMTP id C37102E2D3B
	for <pgsql-performance@postgresql.org>;
	Thu,  6 Mar 2008 02:31:09 -0400 (AST)
Received: by ag-out-0708.google.com with SMTP id 23so2950917agd.5
	for <pgsql-performance@postgresql.org>;
	Wed, 05 Mar 2008 22:31:09 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=PEYV7bh2v+eiKTTRBUb1Ut+J0GVwpLolDvc9ZqDgseE=;
	b=UpRBAGcNoCmiz/XL8bCzPck47qoBQEfCwFokdhYYipPoq6yt1rvQrbu5eGS4SUx23KCxMwnaoPJmkc/dTLRGwHmZHm8DhGbbXqHzZcJX6S4WlVn4QFuC77HbC045tYqM90TumHG5Yk4xzQ5y09hRrknf4T7qvD+LKfI1i+nrcKk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=i7KEPOxWgorVVouN1qBILKkdB48XL2f3oMF1aQ6EhM0fmT8NUhu7icRlVnk7Ld6JlY9lqChxsXj5XHzROLylb+4RT/mJPnfrtUq8YCMnCQXF3KQxkVyUvTpOyyPh22Aw4G3Jx5PS3diTKb9Tzqqag91dvpI1i+ixdwgGANQHtas=
Received: by 10.100.13.2 with SMTP id 2mr9190196anm.29.1204785069173;
	Wed, 05 Mar 2008 22:31:09 -0800 (PST)
Received: by 10.100.105.20 with HTTP; Wed, 5 Mar 2008 22:31:09 -0800 (PST)
Message-ID: <f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com>
Date: Thu, 6 Mar 2008 12:01:09 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: "Shoaib Mir" <shoaibmir@gmail.com>
Subject: Re: count * performance issue
Cc: "A. Kretschmer" <andreas.kretschmer@schollglas.com>,
	pgsql-performance@postgresql.org
In-Reply-To: <bf54be870803052226k64c3b260t632b5043f14eacdb@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3575_32352525.1204785069168"
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>
	<f966c2ee0803052143k4570d771o6c300647d3b987d@mail.gmail.com>
	<20080306060829.GA21084@a-kretschmer.de>
	<bf54be870803052215y5bb56235k5ea05ada1d701022@mail.gmail.com>
	<f966c2ee0803052219x393929c4w321f65e659f1617b@mail.gmail.com>
	<bf54be870803052226k64c3b260t632b5043f14eacdb@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200803/96
X-Sequence-Number: 29050

------=_Part_3575_32352525.1204785069168
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

will you please tell, what is autovacuuming... and wat it ll do... is there
any good article in this....

On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir <shoaibmir@gmail.com> wrote:

> On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <sathiya.psql@gmail.com>
> wrote:
>
> > buy every time i need to put ANALYZE...
> > this takes the same time as count(*) takes, what is the use ??
> >
> >
> >
> Dont you have autovacuuming running in the background which is taking care
> of the analyze as well?
>
> If not then hmm turn it on and doing manual analyze then shouldnt I guess
> take much time!
>
> But yes, I will say if its possible go with the trigger option as that
> might be more helpful and a very fast way to do that.
>
>
> --
> Shoaib Mir
> Fujitsu Australia Software Technology
> shoaibm[@]fast.fujitsu.com.au
>

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

will you please tell, what is autovacuuming... and wat it ll do... is there any good article in this....<br><br><div class="gmail_quote">On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir &lt;<a href="mailto:shoaibmir@gmail.com">shoaibmir@gmail.com</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql &lt;<a href="mailto:sathiya.psql@gmail.com" target="_blank">sathiya.psql@gmail.com</a>&gt; wrote:<br>
</div><div class="gmail_quote"><div class="Ih2E3d"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
buy every time i need to put ANALYZE...<br>this takes the same time as count(*) takes, what is the use ??<div><div></div><div><br><br></div></div></blockquote></div><div><br>Dont you have autovacuuming running in the background which is taking care of the analyze as well?<br>

<br>If not then hmm turn it on and doing manual analyze then shouldnt I guess take much time!<br></div></div><br>But yes, I will say if its possible go with the trigger option as that might be more helpful and a very fast way to do that.<div>
<div></div><div class="Wj3C7c"><br>
<br>-- <br>Shoaib Mir<br>Fujitsu Australia Software Technology<br>shoaibm[@]fast.fujitsu.com.au
</div></div></blockquote></div><br>

------=_Part_3575_32352525.1204785069168--