"Lee Wu" <Lwu@xxxxxxxxxxx> writes: > either > 1. out of memory for query result > 2. killed > 3. crash PG Cases 2 and 3 represent the kernel out-of-memory code going nuts. Google for "OOM kill" and "memory overcommit". IMHO you never want Linux's default memory overcommit behavior on a production server. regards, tom lane
