On Mon, Feb 22, 2010 at 10:17 AM, Frank Heikens <frankheikens@xxxxxxx> wrote: > There is no index on the column transactionid in your PostgreSQL-table, as > there is in your MySQL-table. This explains the difference. > > CREATE INDEX i_transactionid ON public.metarelcloud_transactionlog > (transactionid); Does an index help a sort operation in PostgreSQL? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
