On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang <yanghates...@gmail.com> wrote: > On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman <iney...@perceptron.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general