Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 831002E0055
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 25 Mar 2008 08:54:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 48105-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 25 Mar 2008 08:54:07 -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.240])
	by postgresql.org (Postfix) with ESMTP id ABEE52E0041
	for <pgsql-performance@postgresql.org>;
	Tue, 25 Mar 2008 08:54:07 -0300 (ADT)
Received: by ag-out-0708.google.com with SMTP id 23so6586420agd.5
	for <pgsql-performance@postgresql.org>;
	Tue, 25 Mar 2008 04:54:06 -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=hFoilRtpk5ZXg9z4ta22MfWCBaqFRN2voxjglX3RrQE=;
	b=rrbUZ12qWm/xw8Lth5JHsEopXyQ5um2D1T6/K2jJMNos/i0iyIas4CrP+5C/IrQzOYT4Qol/T9DjOE8KYka8jbfIn++E9Sm32QbR/V60dZKf4FCIrhHqesZitDq4IMNBqLqnoa41/lmtld40kmwaPzIM8zcF+jSjX75gmj8EPjM=
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=qTgrGE89IpEnrl4L4QTHin61g+UvyY/btOWhpBoWp2JywlHN+YcmrXMc4H7qYE2QRtKzvjySYN0K8PtSmyXNhOYyi5ue+lmvITCqXdDQXc9t+KFPpxaPavJYZm8ztjBW7oXr5CLL43IWTswW3Cq0Z5xZUg+j8Z2IEr2VlLapx6o=
Received: by 10.100.140.15 with SMTP id n15mr20910822and.87.1206446046586;
	Tue, 25 Mar 2008 04:54:06 -0700 (PDT)
Received: by 10.100.105.20 with HTTP; Tue, 25 Mar 2008 04:54:06 -0700 (PDT)
Message-ID: <f966c2ee0803250454k716edf4cgcd054e7b563e530c@mail.gmail.com>
Date: Tue, 25 Mar 2008 17:24:06 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: "Harald Armin Massa" <haraldarminmassa@gmail.com>
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
Cc: pgsql-performance@postgresql.org
In-Reply-To: <7be3f35d0803250448h62f47b13mebe0252fca9b90e1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2710_25558789.1206446046568"
References: <f966c2ee0803250442g9ceaf61v2c3f35221fcc6481@mail.gmail.com>
	<7be3f35d0803250448h62f47b13mebe0252fca9b90e1@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/464
X-Sequence-Number: 29418

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

>
> th maximum number of records in one PostreSQL table ist unlimited:
>
am asking for good performance, not just limitation..

If i have half a crore record, how the performance will be ?

>
> http://www.postgresql.org/about/
>
> [for some values of unlimited]
>
> Some further help:
>
> googling for:
> postgresql limits site:postgresql.org
>
but i need some experimentation result...

I have 1 GB RAM with Pentium Celeron.
50 lakh records and postgres performance is not good....

It takes 30 sec for simple queries....

>
>

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

<br><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;"><br>
th maximum number of records in one PostreSQL table ist unlimited:<br>
</blockquote><div>am asking for good performance, not just limitation..<br><br>If i have half a crore record, how the performance will be ?<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>
<a href="http://www.postgresql.org/about/" target="_blank">http://www.postgresql.org/about/</a><br>
<br>
[for some values of unlimited]<br>
<br>
Some further help:<br>
<br>
googling for:<br>
postgresql limits site:<a href="http://postgresql.org" target="_blank">postgresql.org</a><br>
</blockquote><div>but i need some experimentation result... <br><br>I have 1 GB RAM with Pentium Celeron.<br>50 lakh records and postgres performance is not good....<br><br>It takes 30 sec for simple queries....<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></blockquote></div><br>

------=_Part_2710_25558789.1206446046568--