Mike Mascari wrote:
>
>
> Although I am a PostgreSQL zealot, I have to admit that many
> PostgreSQL users have hidden behind the use of transactions in
> justifying the sometimes 2 - 3 times slower execution speeds in
> DML statements vs. MySQL. As Vadim points out in his comparison
> of COPY vs. INSERT, something is *wrong* with the time it takes
> for PostgreSQL to parse, plan, rewrite, and optimize. Now that
> MySQL has transactions through Berkley DB, I think its going to
> be harder to justify the pre-executor execution times.
We can always justify it by referring to extensibility of postgres,
which is surely part of the story
Sure we will be able to do cacheing to improve speed of
serial inserts.
> Just my two cents,
>
> Mike Mascari