On Mon, Feb 22, 2010 at 9:30 PM, Alex Hunsaker <badalex@xxxxxxxxx> wrote: > On Mon, Feb 22, 2010 at 11:10, Yang Zhang <yanghatespam@xxxxxxxxx> wrote: >> I have the exact same table of data in both MySQL and Postgresql. In ?> Postgresql: > > FWIW on a stock (unchanged postgresql.conf) 8.3.9 I get (best of 3 > runs) 79 seconds, 26 using an index and 27 seconds with it clustered. > Now yes it goes a lot faster because im skipping all the overhead of > sending the data to the client... Last sentence also contributed to my realizing the problem (the client I was using was psql), but there's one oddity.... > # select count(1) from (SELECT * from metarelcould_transactionlog > order by transactionid) as foo; Does it strike anyone else that the query optimizer/rewriter should be able to toss out the sort from such a query altogether? -- Yang Zhang http://www.mit.edu/~y_z/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
