Re: Abnormal performance difference between Postgres and MySQL

[Robert Haas <robertmhaas(at)gmail(dot)com>]

> Please note that this (1792MB) is the highest that I could set for work_mem.

Yeah, that's almost certainly part of your problem.

You need to make that number MUCH smaller.  You probably want a value
like 1MB or 5MB or maybe if you have really a lot of memory 20MB.

That's insanely high.

...Robert