X-Original-To: pgsql-advocacy@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E9021475A97 for ; Tue, 11 Feb 2003 20:24:25 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 3255B4758FE for ; Tue, 11 Feb 2003 20:24:25 -0500 (EST) Received: (qmail 6084 invoked by uid 500); 12 Feb 2003 01:37:48 -0000 Date: Tue, 11 Feb 2003 19:37:48 -0600 From: Bruno Wolff III To: "scott.marlowe" Cc: Rick Gigger , Greg Copeland , Tom Lane , Merlin Moncure , PostgresSQL Hackers Mailing List , pgsql-advocacy@postgresql.org Subject: Re: [HACKERS] Changing the default configuration (was Re: Message-ID: <20030212013748.GA5831@wolff.to> Mail-Followup-To: "scott.marlowe" , Rick Gigger , Greg Copeland , Tom Lane , Merlin Moncure , PostgresSQL Hackers Mailing List , pgsql-advocacy@postgresql.org References: <006c01c2d22d$4028c450$0a00000a@grouch> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/32 X-Sequence-Number: 790 On Tue, Feb 11, 2003 at 17:42:06 -0700, "scott.marlowe" wrote: > > The poor performance of Postgresql in it's current default configuration > HAS cost us users, trust me, I know a few we've almost lost where I work > that I converted after some quick tweaking of their database. About two years ago I talked some people into trying it at work to use with IMP/Horde which had been having some corruption problems while using MySQL (though it wasn't necessarily a problem with MySQL). I told them to be sure to use 7.1. When they tried it out it couldn't keep up with the load. I asked the guys what they tried and found out they couldn't find 7.1 rpms and didn't want to compile from source and so ended up using 7.0.?. Also as far as I could tell from talking to them, they didn't do any tuning at all. They weren't interested in taking another look at it after that. We are still using MySQL with that system today. One of our DBAs is using it for some trial projects (including one for me) even though we have a site license for Oracle.