Re: Query runs forever after upgrading to 9.3

[bricklen <bricklen@xxxxxxxxx>]

On Mon, Sep 23, 2013 at 9:12 AM, Andrus <kobruleht2@xxxxxx> 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;