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

From Yang Zhang
Subject Re: Sorting performance vs. MySQL
Date
Msg-id 9066fa251002221108q608c42a8j2c7b4b587ec1127@mail.gmail.com
Whole thread Raw
In response to Re: Sorting performance vs. MySQL  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On Mon, Feb 22, 2010 at 2:03 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Yang Zhang escribió:
>
>> I'm running:
>>
>>   select * from metarelcloud_transactionlog order by transactionid;
>>
>> It takes MySQL 6 minutes, but Postgresql is still running after 70
>> minutes. Is there something like a glaring misconfiguration that I'm
>> overlooking? Thanks in advance.
>
> How large is the table, and have you vacuumed it?  Did you analyze it?
> What Pg version is this?

The table has 50.4M tuples. It's been vacuumed and analyzed. I'm using
PG 8.3.8 on Fedora 10 x86_64.
--
Yang Zhang
http://www.mit.edu/~y_z/

pgsql-general by date:

Previous
From: Yang Zhang
Date:
Subject: Re: Sorting performance vs. MySQL
Next
From: Frank Heikens
Date:
Subject: Re: Sorting performance vs. MySQL