Postgres Pro
Downloads
Home   >   mailing lists

Re: select * and save into a text file failed - Mailing list pgsql-admin

From Tom Lane
Subject Re: select * and save into a text file failed
Date
Msg-id 23836.1118423751@sss.pgh.pa.us
Whole thread Raw
In response to Re: select * and save into a text file failed  ("Lee Wu" <Lwu@mxlogic.com>)
List pgsql-admin
Tree view 
"Lee Wu" <Lwu@mxlogic.com> 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

pgsql-admin by date:

Previous
From: "Lee Wu"
Date:
Subject: Re: select * and save into a text file failed
Next
From: Steve Crawford
Date:
Subject: Re: select * and save into a text file failed