Re: PostgreSQL vs MySQL

On Tue, May 25, 2004 at 09:54:40AM -0400, Alvaro Herrera wrote:
> I'm not sure this would give actual additional performance though,
> because (btree-) index creation appears to be slowed down by excessive
> unnecessary WAL traffic.  I'm sure this can be handled better; Tom Lane

It doesn't buy you linear scaling in performance, because of the WAL
issues you metioned.  But because index creation is also sort-heavy,
it's still a big help.  Chris and I know this from experience,
because we used this very strategy (his proposal, I note) in
importing the .org database.  I mentioned this approach at OSCON last
year.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner