X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9D16AD1ED6E for ; Mon, 5 Apr 2004 14:54:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96903-07 for ; Mon, 5 Apr 2004 11:54:38 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 86A9FD1ED6C for ; Mon, 5 Apr 2004 11:54:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i35EqCOo011309; Mon, 5 Apr 2004 10:52:12 -0400 (EDT) To: reina_ga@hotmail.com (Tony Reina) Cc: pgsql-admin@postgresql.org Subject: Re: Do Petabyte storage solutions exist? In-reply-to: <272e4be7.0404042344.229c7475@posting.google.com> References: <406D4289.8040801@kieser.net> <272e4be7.0404042344.229c7475@posting.google.com> Comments: In-reply-to reina_ga@hotmail.com (Tony Reina) message dated "05 Apr 2004 00:44:12 -0700" Date: Mon, 05 Apr 2004 10:52:12 -0400 Message-ID: <11308.1081176732@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/44 X-Sequence-Number: 13017 reina_ga@hotmail.com (Tony Reina) writes: > The PostgreSQL limitations on the users' page > (http://www.postgresql.org/users-lounge/limitations.html) still says > that tables are limited to 16 TB, not 32 TB. > Perhaps it should be updated? There was some concern at the time it was written as to whether we were sure that we'd fixed all the places that treated block numbers as signed rather than unsigned ints. I still misdoubt that this should be considered a tested and guaranteed-to-work thing. Those who have done any testing of, eg, VACUUM FULL on greater-than-16TB tables, please raise your hands? regards, tom lane