Re: select * and save into a text file failed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lee Wu" <Lwu(at)mxlogic(dot)com>
Cc: "Steve Crawford" <scrawford(at)pinpointresearch(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: select * and save into a text file failed
Date: 2005-06-10 17:15:51
Message-ID: 23836.1118423751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Lee Wu" <Lwu(at)mxlogic(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2005-06-10 17:36:09 Re: select * and save into a text file failed
Previous Message Lee Wu 2005-06-10 17:05:31 Re: select * and save into a text file failed