From: Mark Kirkwood <markir@paradise.net.nz>
To: Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
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 13:32:53 +1200
Message-ID: <4446E4C5.90400@paradise.net.nz> (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>
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.
Might be for the binaries from www.mysql.com - but if you build from
source, it still seems to be MYISAM (checked with 5.0.18 and 5.1.7 here).
Cheers
Mark
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: markir@paradise.net.nz, chris.kings-lynne@calorieking.com, tgl@sss.pgh.pa.us, smarlowe@g2switchworks.com, schabi@logix-tt.com, mha@sollentuna.net
Subject: Re: Inserts optimization?
In-Reply-To: <4446E4C5.90400@paradise.net.nz>
* 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