On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang <yanghatespam@xxxxxxxxx> wrote: > On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: >> When in doubt - test. >> Why not remove index in MySQL (or create index in PostgreSQL) and see >> what happens. >> Why trying compare "apples and oranges"? > > Continue reading this thread -- I also tried using an index in Postgresql. But have you tried cranking up work_mem to say 1G? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general