Re: [HACKERS] Changing the default configuration (was Re:

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Rick Gigger <rick(at)alpinenetworking(dot)com>, Greg Copeland <greg(at)CopelandConsulting(dot)Net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Date: 2003-02-12 01:37:48
Message-ID: 20030212013748.GA5831@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-performance

On Tue, Feb 11, 2003 at 17:42:06 -0700,
"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> 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.

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tatsuo Ishii 2003-02-12 02:00:00 Re: Changing the default configuration
Previous Message scott.marlowe 2003-02-12 01:23:28 Re: Changing the default configuration

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2003-02-12 01:56:56 Contract Programmer Advice.
Previous Message scott.marlowe 2003-02-12 01:23:28 Re: Changing the default configuration

Browse pgsql-performance by date

  From Date Subject
Next Message Tatsuo Ishii 2003-02-12 02:00:00 Re: Changing the default configuration
Previous Message scott.marlowe 2003-02-12 01:23:28 Re: Changing the default configuration