Re: Sorting performance vs. MySQL - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Sorting performance vs. MySQL
Date
Msg-id dcc563d11002221551m6ae5e742j889521648213dbeb@mail.gmail.com
Whole thread Raw
In response to Re: Sorting performance vs. MySQL  (Yang Zhang <yanghatespam@gmail.com>)
List pgsql-general
On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang <yanghatespam@gmail.com> wrote:
> On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman <ineyman@perceptron.com> wrote:
>> When in doubt - test.
>> Why not remove index in MySQL (or create index in PostgreSQL) and see
>> what happens.
>> Why trying compare "apples and oranges"?
>
> Continue reading this thread -- I also tried using an index in Postgresql.

But have you tried cranking up work_mem to say 1G?

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: tuning bgwriter in 8.4.2
Next
From: Scott Marlowe
Date:
Subject: Re: Sorting performance vs. MySQL