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 C2FB6534BB for ; Wed, 23 Mar 2005 22:22:14 +0000 (GMT) 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 50808-05 for ; Wed, 23 Mar 2005 22:22:11 +0000 (GMT) Received: from srv.fgp.com (srv.fgp.com [68.17.101.178]) by svr1.postgresql.org (Postfix) with ESMTP id 286DE534EB for ; Wed, 23 Mar 2005 22:22:10 +0000 (GMT) Received: (from apache@localhost) by srv.fgp.com (8.11.6/8.11.6) id j2NMM6u13743; Wed, 23 Mar 2005 17:22:06 -0500 Received: from 192.168.0.6 (SquirrelMail authenticated user jnalley); by srv.fgp.com with HTTP; Wed, 23 Mar 2005 17:22:06 -0500 (EST) Message-ID: <4682.192.168.0.6.1111616526.squirrel@192.168.0.6> In-Reply-To: References: Date: Wed, 23 Mar 2005 17:22:06 -0500 (EST) Subject: Re: Any examples of companies using PG in high volume From: "Jonathan Nalley" To: "David B" Cc: pgsql-admin@postgresql.org Reply-To: jnalley@fgp.com User-Agent: SquirrelMail/1.4.3 [CVS] X-Mailer: SquirrelMail/1.4.3 [CVS] MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/375 X-Sequence-Number: 16873 you'll probably find some answers in the comments of a similar Slashdot post: http://it.slashdot.org/article.pl?sid=05/03/21/1635210 Check out http://advocacy.postgresql.org Two other examples are Whitepages.com (375GB) and the .org registry as well. On Wed, March 23, 2005 17:07, David B said: > I've been looking for examples of high volume (in terms of throughput) > and large scale (500GB-terabtype+) examples of Postgres > impllmenetations. > > I keep seeing the same few examples (BASF, Los Alamos Labs, Futijsu > and .info administrator). Impossible to tell anything from the names. > .info administrator might be dealing with 100 transactions per > hour...or per second. Not seen anything on that. And a few hundred > .info records may add up to less than 1GB. > > I've seen nothing showing real world numbers in terms of hourly/daily > transactions activity and nothing showing how large the databases > really are. > >>From experience I've come to seek clarification of the meaning of > statements such as "we have a hugh database". One persons hugh is 1GB > while another's is 100GB while another's is 1TB+. And as one who has > dealt with TB+ in Oracle the issues are way different. > > Can any of you suggest some companies I can point to as I try to > convince my company to move to it. We will be storing 100's GB of > data. > > tia > David > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >