Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id D90D02E2E8B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  6 Mar 2008 02:32:54 -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 10805-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  6 Mar 2008 02:32:49 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.171])
	by postgresql.org (Postfix) with ESMTP id 993C32E027C
	for <pgsql-performance@postgresql.org>;
	Thu,  6 Mar 2008 02:32:51 -0400 (AST)
Received: by wf-out-1314.google.com with SMTP id 28so2106603wff.28
	for <pgsql-performance@postgresql.org>;
	Wed, 05 Mar 2008 22:32:50 -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=MSp19R8eLRrqaU1HkKGwVe54lXwnczLP1GYEkO3Qg4I=;
	b=R7R5h9+d7g17DwKBOAWBhHqW27jhtiK62svQL+1g2NWzfEbjRYFbtdH9RLcanzRK0Jb4aHZRb+OPnfGwMwuFdDOiDYPD2IHgtJA1gp6NDWmL2tRt0ojH5cpBkYkrj/bdzZoktlJiZ69jaYT3I5YVHOja7RYcQtEl+9qU8/xqfYg=
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=v7E1fpVAl8cRdTctiRm1j09QDCcuPttKOYy4XwBjrV8NTYt/8qPUNh1oJz2lvc1PdEKtgbKa6tzhMufSP/qu8eIyuoif6KEDPWC0gbwGDndop2T773wBSX8YLIaz5/FccRbtIh6xI/5XJjgHGVWn+uZ6Ue5tvgbPqfrcyIH7a7g=
Received: by 10.142.231.7 with SMTP id d7mr1109981wfh.30.1204785170666;
	Wed, 05 Mar 2008 22:32:50 -0800 (PST)
Received: by 10.142.231.18 with HTTP; Wed, 5 Mar 2008 22:32:50 -0800 (PST)
Message-ID: <bf54be870803052232o2c560edcvf45a3dcf8b6fe93f@mail.gmail.com>
Date: Thu, 6 Mar 2008 17:32:50 +1100
From: "Shoaib Mir" <shoaibmir@gmail.com>
To: "sathiya psql" <sathiya.psql@gmail.com>
Subject: Re: count * performance issue
Cc: "A. Kretschmer" <andreas.kretschmer@schollglas.com>,
	pgsql-performance@postgresql.org
In-Reply-To: <f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_36817_2511979.1204785170629"
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>
	<f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/97
X-Sequence-Number: 29051

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

On Thu, Mar 6, 2008 at 5:31 PM, sathiya psql <sathiya.psql@gmail.com> wrote:

> will you please tell, what is autovacuuming... and wat it ll do... is
> there any good article in this....
>
>
>
Read this -->
http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#AUTOVACUUM

-- 
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm[@]fast.fujitsu.com.au

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

<br><br><div class="gmail_quote">On Thu, Mar 6, 2008 at 5:31 PM, sathiya psql &lt;<a href="mailto:sathiya.psql@gmail.com">sathiya.psql@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;">
will you please tell, what is autovacuuming... and wat it ll do... is there any good article in this....<br><br><br>
</blockquote></div><br>Read this --&gt; <a href="http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#AUTOVACUUM">http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#AUTOVACUUM</a><br clear="all">
<br>-- <br>Shoaib Mir<br>Fujitsu Australia Software Technology<br>shoaibm[@]fast.fujitsu.com.au

------=_Part_36817_2511979.1204785170629--