Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 493472E002D for ; Tue, 25 Mar 2008 09:23:50 -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 60990-04 for ; Tue, 25 Mar 2008 09:23:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by postgresql.org (Postfix) with ESMTP id 0A8902E002C for ; Tue, 25 Mar 2008 09:23:37 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 22so3222321fge.23 for ; Tue, 25 Mar 2008 05:23:36 -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:content-transfer-encoding:content-disposition:references; bh=AXz48WvSoLgA+lZOewkZ6q77aYE2Q46M8SjzZBsHSSs=; b=lKK0Q6BRsvkbjz8q3LrRi0nZ5Hu8JLAFQE3a+8buXsNUluDIuGaaNtY5hBerw4dPj+BD2x/Rjzky/KKKDRP1Bu5JhdhRNqmGnk0PujZnCOMQnymK9EdjODuYXW0ubWjGD5ANKaZL49rD/pyt1lvvrR9KulR9XVu44IOMGCBEd18= 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:content-transfer-encoding:content-disposition:references; b=sIOUYOq4pgFLpq55XGTcNrJnoWczJ9TpEfzOxrYMw3FTq7LEMR2Adx/1PwI0BA3mLaD/4aqftTYDTd0nH0NwwK62QPRcuQ3hvm/PB8WuDqyCsM5+dmVZc4k/HnA1rVqKEZCXWgITI7kwR2HYUuU46DLUxjlljbywLrYEMQestkA= Received: by 10.82.166.9 with SMTP id o9mr20793035bue.33.1206447816223; Tue, 25 Mar 2008 05:23:36 -0700 (PDT) Received: by 10.82.113.12 with HTTP; Tue, 25 Mar 2008 05:23:36 -0700 (PDT) Message-ID: <396486430803250523h6406292am491f28e45c07a1f5@mail.gmail.com> Date: Tue, 25 Mar 2008 05:23:36 -0700 From: "Richard Broersma" To: "sathiya psql" Subject: Re: what is the maximum number of rows in a table in postgresql 8.1 Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <396486430803250510t58a5532coc7955463101395c0@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/209 X-Sequence-Number: 28692 On Tue, Mar 25, 2008 at 5:12 AM, sathiya psql wrote: > i need what will be the maximum number of rows to have good performance in > postgres 8.1 This article give you the options that you have with postgresql. http://www.commandprompt.com/blogs/joshua_drake/2007/08/how_many_rows_do_i_have_anyway/ Regards, Richard Broersma Jr.