On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang <yanghatespam@gmail.com> wrote:
> On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman <ineyman@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?