Thread: Re: [HACKERS] What can we learn from MySQL?

Re: [HACKERS] What can we learn from MySQL?

From
"Merlin Moncure"
Date:
Chris Travers wrote:
> I second that.  I have not found *anybody* who has used Oracle's
> installer to install the actual database server on Linux or Solaris
who
> has described their installation proceedure as either "nice" or
"easy."
> In fact even reading the installation isntructions is enough to give
you
> second thoughts....  MS SQL does have a nice installer, however, as do
> most binary open source products for Windows.  I am completely
confident
> that PostgreSQL for Windows, when it arrives, will have a nice
GUI-based
> installer.

There is already one in development that does pretty much everything one
would expect.

MS SQL server is as simple as it is because it is very tightly
integrated with the virtual memory subsystem that drives the OS (no
equivalent to shared buffers setting).  This provides good performance
but it is not really possible to do this in a cross platform kind of
way.  Furthermore, apps that do not play nice with the v-mem subsystem
can wreck your server by causing it to thrash...in short, maybe their
installation is a little bit *too* simple...

Merlin