X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1482052812 for ; Thu, 30 Jun 2005 07:04:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78131-05 for ; Thu, 30 Jun 2005 10:04:02 +0000 (GMT) Received: from as2.cineca.com (as2.cineca.com [130.186.84.242]) by svr1.postgresql.org (Postfix) with ESMTP id 4D710529BE for ; Thu, 30 Jun 2005 07:03:54 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by as2.cineca.com (Postfix) with ESMTP id 13BF865931 for ; Thu, 30 Jun 2005 12:03:56 +0200 (CEST) Received: from cineca.mm.cineca.it (cineca.mm.cineca.it [130.186.10.200]) by as2.cineca.com (Postfix) with ESMTP id DF8406595A for ; Thu, 30 Jun 2005 12:03:52 +0200 (CEST) Received: from [130.186.7.197] (dhcp7-197.cineca.it [130.186.7.197]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) as user f.dallaca@cineca.it by cineca.mm.cineca.it (Postfix) with ESMTP id 247BF31FA53 for ; Thu, 30 Jun 2005 12:03:47 +0200 (MEST) Message-ID: <42C3C382.5020108@cineca.it> From: Francesco Dalla Ca' Organization: CINECA User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050513 Fedora/1.7.8-1.3.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: postgres teoretical and (best-)pratical size limits Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Date: Thu, 30 Jun 2005 12:03:47 +0200 (MEST) X-Virus-Scanned: Cineca AppOs 0.85 at as2.cineca.com X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/283 X-Sequence-Number: 18038 I have some questions about the subject. in the postgresql F.A.Q.: http://www.postgresql.org/docs/faqs.FAQ.html#4.4 "... 4.4) What is the maximum size for a row, a table, and a database? These are the limits: Maximum size for a database? unlimited (32 TB databases exist) Maximum size for a table? 32 TB Maximum size for a row? 1.6TB Maximum size for a field? 1 GB Maximum number of rows in a table? unlimited Maximum number of columns in a table? 250-1600 depending on column types Maximum number of indexes on a table? unlimited ..." 1) How are computed the maximum size of a table? On the manual: http://www.postgresql.org/docs/8.0/interactive/sql-createtable.html "... A table cannot have more than 1600 columns. (In practice, the effective limit is lower because of tuple-length constraints.) ..." 2) What's the tuple-length constraint? (and what's the max tuple-length?) 3) These are teoretical limits, but exists some licterature (articles, examples, case-studies) what addresses on pratical performance degradation derived from use of large tables with large amount of data? (eg.: max tables size suggested, max rows, max tuple size...) Thanks for the answers and best regards.