Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CA7DA2E0051 for ; Tue, 25 Mar 2008 09:44:56 -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 42629-02 for ; Tue, 25 Mar 2008 09:44:42 -0300 (ADT) X-Greylist: delayed 00:25:52.572048 by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 763F92E002C for ; Tue, 25 Mar 2008 09:44:50 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 4F0B247006C for ; Tue, 25 Mar 2008 13:18:52 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lB7n8a45dQ-v for ; Tue, 25 Mar 2008 13:18:52 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 3D96E470002; Tue, 25 Mar 2008 13:18:52 +0100 (CET) Date: Tue, 25 Mar 2008 13:18:52 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: what is the maximum number of rows in a table in postgresql 8.1 Message-ID: <20080325121852.GF10192@easy2.in-chemnitz.de> References: <396486430803250510t58a5532coc7955463101395c0@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/210 X-Sequence-Number: 28693 On Tue, Mar 25, 2008 at 05:42:46PM +0530, sathiya psql wrote: > > I am not sure I understand your question. maybe this link answers > > your question: > > http://www.postgresql.org/about/ > > > this i know..... > > this is the documentation limitations... > > i need what will be the maximum number of rows *to have good performance* in > postgres 8.1 That depends on your database schema and the queries you're running. We've got PostgreSQL 8.2 databases with over 200 million rows in a table and it's performing well. And there are possibly larger databases around. Bye, Tino. -- www.craniosacralzentrum.de www.spiritualdesign-chemnitz.de www.forteego.de Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz