From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Markus Schaber <schabi@logix-tt.com>
Cc: Magnus Hagander <mha@sollentuna.net>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Inserts optimization?
Date: Thu, 20 Apr 2006 09:16:27 -0500
Message-ID: <1145542587.23538.131.camel@state.g2switchworks.com> (raw)
In-Reply-To: <4446DED2.3040307@calorieking.com>
References: <6BCB9D8A16AC4241919521715F4D8BCEA352AE@algol.sollentuna.se>
<44462849.3070209@logix-tt.com>
<1145460130.23538.119.camel@state.g2switchworks.com>
<26519.1145460679@sss.pgh.pa.us>
<4446DED2.3040307@calorieking.com>
On Wed, 2006-04-19 at 20:07, Christopher Kings-Lynne wrote:
> > Scott Marlowe <smarlowe@g2switchworks.com> writes:
> >> It's the refusal of people to stop using MyISAM table types that's the
> >> real issue.
> >
> > Isn't MyISAM still the default over there? It's hardly likely that the
> > average MySQL user would use anything but the default table type ...
>
> Since MySQL 5, InnoDB tables are default I recall.
It gets built by default, but when you do a plain create table, it will
still default to myisam tables.
Note that there is a setting somewhere in my.cnf that will make the
default table type anything you want.
For Bacula though, what I was suggesting was that they simply declare
that you need innodb table type support if you want decent performance,
then coding to that, and if someone doesn't have innodb table support,
then they have no right to complain about poor performance. Seems a
fair compromise to me. The Bacula folks would get to program to a real
database model with proper serlialization and all that, and the people
who refuse to move up to a later model MySQL get crappy performance.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, chris.kings-lynne@calorieking.com, tgl@sss.pgh.pa.us, schabi@logix-tt.com, mha@sollentuna.net
Subject: Re: Inserts optimization?
In-Reply-To: <1145542587.23538.131.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox