Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9F4B32E003B for ; Tue, 25 Mar 2008 10:58:01 -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 58145-06 for ; Tue, 25 Mar 2008 10:57:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136033.authsmtp.net (outmail136033.authsmtp.net [62.13.136.33]) by postgresql.org (Postfix) with ESMTP id 457B42E003C for ; Tue, 25 Mar 2008 10:57:58 -0300 (ADT) Received: from squirrel.dmpriest.net.uk (squirrel.dmpriest.net.uk [62.13.128.25]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m2PDvs8r073462; Tue, 25 Mar 2008 13:57:55 GMT Received: from [192.168.0.3] (85-211-64-98.dyn.gotadsl.co.uk [85.211.64.98]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m2PDvqAN084874; Tue, 25 Mar 2008 13:57:52 GMT Subject: Re: what is the maximum number of rows in a table in postgresql 8.1 From: Simon Riggs To: sathiya psql Cc: Richard Broersma , pgsql-admin@postgresql.org In-Reply-To: References: <396486430803250510t58a5532coc7955463101395c0@mail.gmail.com> Content-Type: text/plain Date: Tue, 25 Mar 2008 13:59:05 +0000 Message-Id: <1206453545.4285.908.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 763898df-fa73-11dc-b66f-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFagBbYFhD HGQLW1xEUV57XGR/ bggfZQBDYEtPQQNu TkFBXVBXCwUmXB5h clhfI2dyfwFOf3o+ ZENjXT5cWkdyfE4p FFMCRGoFeGZhPDMC AkZeIR5UcAJCeR4Q Y1N/AndDAzANdhER MyoSGQV5IjVWNGxU WUkRLV9aRE8bHzsh QlgEADAlEFdNQCt7 NRs5MRYdGg4Yelk7 O18sEVMeUX4KDRZC EFtAGzZdbwlHHkJW X-Authentic-SMTP: 61633235383639.cat.dmpriest.net.uk:787/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/211 X-Sequence-Number: 28694 On Tue, 2008-03-25 at 17:42 +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 You want a simple answer to a very difficult question and regrettably it isn't that simple or that quick. Some of the considerations you would need to think about would be: * What workloads are you running? * What hardware will it run on? * What performance is required? ... -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk