Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0SFiSq78223 for ; Sun, 28 Jan 2001 10:44:28 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id KAA01275; Sun, 28 Jan 2001 10:44:19 -0500 (EST) From: Bruce Momjian Message-Id: <200101281544.KAA01275@candle.pha.pa.us> Subject: Re: postgres limitation In-Reply-To: "from The Hermit Hacker at Jan 27, 2001 10:02:10 pm" To: The Hermit Hacker Date: Sun, 28 Jan 2001 10:44:19 -0500 (EST) CC: Tom Lane , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200101/190 X-Sequence-Number: 567 > > > Maximum size for a table? > > > > > > 2G blocks, hence 16 to 64 terabytes depending on the BLCKSZ > > > configuration constant. (If someone were to run around and make sure > > > all the block-number arithmetic is unsigned, we could claim 4G blocks, > > > but I think it's not all unsigned now...) Added to TODO: * Make sure all block numbers are unsigned to increase maximum table size -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026