"Lee Wu" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
