X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 110563A535F for ; Mon, 10 Jan 2005 00:04:15 +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 33691-07 for ; Mon, 10 Jan 2005 00:04:01 +0000 (GMT) Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr1.postgresql.org (Postfix) with ESMTP id F10223A3BDF for ; Mon, 10 Jan 2005 00:04:02 +0000 (GMT) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id j0A04HtK012276; Sun, 9 Jan 2005 18:04:20 -0600 Date: Sun, 9 Jan 2005 18:04:52 -0600 From: Frank Wiles To: Randolf Richardson Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL vs. Oracle vs. Microsoft Message-Id: <20050109180452.03723387.frank@wiles.org> In-Reply-To: References: X-Mailer: Sylpheed version 0.9.10 (GTK+ 1.2.10; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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: 200501/101 X-Sequence-Number: 9791 On Thu, 6 Jan 2005 19:01:38 +0000 (UTC) Randolf Richardson wrote: > I'm looking for recent performance statistics on PostgreSQL vs. > Oracle > vs. Microsoft SQL Server. Recently someone has been trying to > convince my client to switch from SyBASE to Microsoft SQL Server (they > originally wanted to go with Oracle but have since fallen in love with > Microsoft). All this time I've been recommending PostgreSQL for cost > and stability (my own testing has shown it to be better at handling > abnormal shutdowns and using fewer system resources) in addition to > true cross-platform compatibility. > > If I can show my client some statistics that PostgreSQL > outperforms > these (I'm more concerned about it beating Oracle because I know that > Microsoft's stuff is always slower, but I need the information anyway > to protect my client from falling victim to a 'sales job'), then > PostgreSQL will be the solution of choice as the client has always > believed that they need a high-performance solution. > > I've already convinced them on the usual price, cross-platform > compatibility, open source, long history, etc. points, and I've been > assured that if the performance is the same or better than Oracle's > and Microsoft's solutions that PostgreSQL is what they'll choose. While this doesn't exactly answer your question, I use this little tidbit of information when "selling" people on PostgreSQL. PostgreSQL was chosen over Oracle as the database to handle all of the .org TLDs information. While I don't believe the company that won was chosen solely because they used PostgreSQL vs Oracle ( vs anything else ), it does go to show that PostgreSQL can be used in a large scale environment. Another tidbit you can use in this particular case: I was involved in moving www.ljworld.com, www.lawrence.com, and www.kusports.com from a Sybase backend to a PostgreSQL backend back in 2000-2001. We got roughly a 200% speed improvement at that time and PostgreSQL has only improved since then. I would be more than happy to elaborate on this migration off list if you would like. kusports.com gets a TON of hits especially during "March Madness" and PostgreSQL has never been an issue in the performance of the site. --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------