Re: [HACKERS] A Better External Sort?

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: Ron Peacetree <rjpeace(at)earthlink(dot)net>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] A Better External Sort?
Date: 2005-10-01 14:03:52
Message-ID: 1128175432.5359.11.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On R, 2005-09-30 at 13:38 -0700, Luke Lonergan wrote:

>
> Bulk loading speed is irrelevant here - that is dominated by parsing, which
> we have covered copiously (har har) previously and have sped up by 500%,
> which still makes Postgres < 1/2 the loading speed of MySQL.

Is this < 1/2 of MySQL with WAL on different spindle and/or WAL
disabled ?

--
Hannu Krosing <hannu(at)skype(dot)net>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message mark 2005-10-01 14:05:22 Re: effective SELECT from child tables
Previous Message Martijn van Oosterhout 2005-10-01 12:13:09 Re: effective SELECT from child tables

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Peacetree 2005-10-01 14:22:40 Re: [HACKERS] A Better External Sort?
Previous Message hubert depesz lubaczewski 2005-10-01 10:01:04 Re: database bloat, but vacuums are done, and fsm seems to be setup ok