Re: [PERFORM] OOM-killer issue with a specific query 9 of 20)

2011-12-20 Thread Tom Lane
nabble.30.miller_2...@spamgourmet.com writes: > I've run EXPLAIN on the query, but AFAICS the query plan does not > appear significantly different than the abridged version for this > particular query (output attached below). I think what's happening is that you've got the hashed NOT IN being push

Re: [PERFORM] OOM-killer issue with a specific query 9 of 20)

2011-12-20 Thread nabble . 30 . miller_2555
On Tue, Dec 20, 2011 at 8:24 AM, Scott Marlowe - scott.marl...@gmail.com <+nabble+miller_2555+3b65e832a3.scott.marlowe#gmail@spamgourmet.com> wrote: > > On Mon, Dec 19, 2011 at 8:52 AM,   > wrote: > > I can probably fix by making the following sysctl adjustments: > > vm.overcommit_memory =