Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 3EA712E008F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 25 Mar 2008 09:09:03 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 31262-04-6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 25 Mar 2008 09:08:52 -0300 (ADT)
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.241])
	by postgresql.org (Postfix) with ESMTP id 1DFBB2E0082
	for <pgsql-performance@postgresql.org>;
	Tue, 25 Mar 2008 09:08:26 -0300 (ADT)
Received: by ag-out-0708.google.com with SMTP id 23so6597329agd.5
	for <pgsql-performance@postgresql.org>;
	Tue, 25 Mar 2008 05:08:25 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; 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;
	bh=WjQnmwYuGtQL6HjHAKpY/J/wV8trTUbvdtV+Lx1lAGo=;
	b=cJjUWt6+68a0mMPnPsZoyQJsnibA0A8pm3OZLzrsJVz2TyM/5/y0toxQGrJbut2gUWtrttlkhZrg2AFtRPWZAcwtYhoThxhgtr/cbVSsbF16GUhAPM8wgO1g7mxU+UszdNASG4YhIsMmBde24Ncrxf/G6gxsR/79dD3mjzWnsEA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=CN8eZ9UAzxADFjILzyhbmDGZK4U2zqV0KpEE44uf9HlPbW/fS0FBPdKxXU2xGUE28xJhQiyjwh6UZs/L++nqeMiQr7B99Y0opo09ItX31XosqFd2vAHN4AeCQ8ABbs5JP9amJkY0vg3OO4mhrEPbcPcuAw9fkyIeG4ea6qW6Hyc=
Received: by 10.100.253.12 with SMTP id a12mr18269116ani.56.1206446904964;
	Tue, 25 Mar 2008 05:08:24 -0700 (PDT)
Received: by 10.100.105.20 with HTTP; Tue, 25 Mar 2008 05:08:24 -0700 (PDT)
Message-ID: <f966c2ee0803250508t444524b6y44b9ee67c8e04673@mail.gmail.com>
Date: Tue, 25 Mar 2008 17:38:24 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
Cc: "Harald Armin Massa" <haraldarminmassa@gmail.com>,
	pgsql-performance@postgresql.org
In-Reply-To: <20080325120101.GC6756@alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2772_2623071.1206446904957"
References: <f966c2ee0803250442g9ceaf61v2c3f35221fcc6481@mail.gmail.com>
	<7be3f35d0803250448h62f47b13mebe0252fca9b90e1@mail.gmail.com>
	<f966c2ee0803250454k716edf4cgcd054e7b563e530c@mail.gmail.com>
	<20080325120101.GC6756@alvh.no-ip.org>
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/467
X-Sequence-Number: 29421

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

>
>
>
> Shows us the explain analyze.  There is no problem with a large number
> of records, as long as you're not expecting to process all of them all
> the time.

yes many a times i need to process all the records,

often i need to use count(*) ????

so what to do  ?? ( those trigger options i know already, but i wil l do
count on different parameters )

>
>
>

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

<div class="gmail_quote"><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"><br>
<br>
</div>Shows us the explain analyze. &nbsp;There is no problem with a large number<br>
of records, as long as you&#39;re not expecting to process all of them all<br>
the time.</blockquote><div>yes many a times i need to process all the records,<br><br>often i need to use count(*) ????<br><br>so what to do&nbsp; ?? ( those trigger options i know already, but i wil l do count on different parameters )<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
<br></blockquote></div><br>

------=_Part_2772_2623071.1206446904957--