On Mon, Feb 22, 2010 at 12:10 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> I've left it running over night. By >> comparison, a "select * from metarelcloud_transactionlog order by >> transactionid" takes on the order of seconds/minutes (at least in >> MySQL). > > That's got approximately nothing to do with this query.
Isn't that exactly what the leaf sorts are doing? By comparison, "select * from metarelcloud_transactionlog order by transactionid" takes much, much longer in PG (it's been running for 68 minutes now, and still going, whereas MySQL took 6 minutes). -- Yang Zhang http://www.mit.edu/~y_z/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
