Re: [GENERAL] Query runs forever after upgrading to 9.3

[bricklen]

On Mon, Sep 23, 2013 at 9:12 AM, Andrus <kobrule...@hot.ee> wrote:

>
> work_mem = 400MB
>
> Hope that this is OK.
>

For cluster-wide setting you will probably want to drop that significantly
-- start lower, as in somewhere around 10MB and work up from there as
necessary. For the queries you are finding slow (the reason for these
emails) you can set work_mem specifically for the session.
Eg.
set work_mem to '400MB';
<run your query>
reset work_mem;