On Mon, Feb 22, 2010 at 2:03 PM, Alvaro Herrera <alvhe...@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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
