X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3A40ED1E900 for ; Wed, 5 May 2004 18:11:48 -0300 (ADT) 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 50709-08 for ; Wed, 5 May 2004 18:11:30 -0300 (ADT) Received: from mx1.neopolitan.us (mx1.neopolitan.us [65.87.16.224]) by svr1.postgresql.org (Postfix) with ESMTP id 63A1DD1DC64 for ; Wed, 5 May 2004 18:11:27 -0300 (ADT) Received: from [65.87.16.98] (HELO [10.0.0.210]) by mx1.neopolitan.us (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 4156961; Wed, 05 May 2004 14:11:29 -0700 Subject: Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL From: "J. Andrew Rogers" To: Carlos Eduardo Smanioto Cc: pgsql-performance@postgresql.org In-Reply-To: <034d01c44b2e$ae9b2b00$cf00a8c0@smannote> References: <034d01c44b2e$ae9b2b00$cf00a8c0@smannote> Content-Type: text/plain Organization: Message-Id: <1083791489.11496.23.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 05 May 2004 14:11:29 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/43 X-Sequence-Number: 6874 On Sat, 2004-06-05 at 11:55, Carlos Eduardo Smanioto wrote: > What's the case of bigger database PostgreSQL (so greate and amount of > registers) that they know??? You might want to fix the month on your system time. With respect to how big PostgreSQL databases can get in practice, these are our two biggest implementations: - 0.5 Tb GIS database (this maybe upwards of 600-700Gb now, I didn't check) - 10 Gb OLTP system with 70 million rows and a typical working set of 2-3 Gb. Postgres is definitely capable of handling large pretty databases with ease. There are some narrow types of workloads that it doesn't do so well on, but for many normal DBMS loads it scales quite well. j. andrew rogers