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 DE54CD1D84E for ; Fri, 2 Apr 2004 17:41:29 +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 03193-02 for ; Fri, 2 Apr 2004 13:41:34 -0400 (AST) Received: from fep03-mail.bloor.is.net.cable.rogers.com (fep03-mail.bloor.is.net.cable.rogers.com [66.185.86.73]) by svr1.postgresql.org (Postfix) with ESMTP id 720BAD1BC59 for ; Fri, 2 Apr 2004 13:41:27 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep03-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040402174109.BOUG396979.fep03-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 2 Apr 2004 12:41:09 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 13B633D2B; Fri, 2 Apr 2004 12:41:32 -0500 (EST) Date: Fri, 2 Apr 2004 12:41:32 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Do Petabyte storage solutions exist? Message-ID: <20040402174132.GA9402@phlogiston.dyndns.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <272e4be7.0404010941.4413c82c@posting.google.com> <406C6513.9070105@kieser.net> <406D421C.4010506@kieser.net> <406D8DF1.9080007@kieser.net> <27880.1080920548@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <27880.1080920548@sss.pgh.pa.us> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep03-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Fri, 2 Apr 2004 12:41:09 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/28 X-Sequence-Number: 13001 On Fri, Apr 02, 2004 at 10:42:28AM -0500, Tom Lane wrote: > I'm fairly sure that Oracle's pricing scales with the iron you plan to > use: the more or faster CPUs you want to run it on, the more you pay. > A large shop can easily get into the $100K license range, but Oracle > figures that they will have spent way more than that on their hardware. This is correct. For a system that I happen to know about, the all-licenses-in (part of which was a large commercial database we may or may not be discussing, part some other application server &c.) price was US$8M (software only). This price was arrived at near the end of the dotcom nonsense; I get the feeling that things are somewhat better now. The license fees were that high because of the number of processors, the amount of memory, and the number and class of machines involved. Something which is worth noting, however, is that (at least in my experience) the curve of the license fees gets very steep near the end. So, if you're working on 4-way machines and think you'll double up by adding 4 more processors, you're sadly mistaken. This investment is part of what causes the adoption rate for new systems in large shops to be so low: if you're already spending several millions on licenses for one product, the incremental cost of adding another license is hardly noticable, and the savings to be realised by moving to a competitor is usually relatively small; but the cost of shifting is very large, because of knowlege, retraining, porting, &c. For Postgres, however, it is a tremendous opportunity: if it can make the last steps to be truly broadly competitive with Oracle and DB2, the potential savings really is large enough to justify the change. Postgres is already there for some kinds of use (I think it provides my employer with a great advantage), but it likely needs a few more features to take the last steps. A -- Andrew Sullivan | ajs@crankycanuck.ca