From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
---|---|
To: | pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: PostgreSQL vs MySQL |
Date: | 2004-05-28 15:25:16 |
Message-ID: | 20040528152516.GA21203@phlogiston.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Gardner | 2004-05-28 20:23:45 | Re: have you seen this? |
Previous Message | efesar (the kay) | 2004-05-28 14:49:43 | Re: [pgsql-advocacy] win32 port getting popular |