Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZTqAs-0002aF-Cv for pgsql-performance@arkaria.postgresql.org; Mon, 24 Aug 2015 11:44:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZTqAr-0001qN-Lq for pgsql-performance@arkaria.postgresql.org; Mon, 24 Aug 2015 11:44:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZTqAr-0001q7-4M for pgsql-performance@postgresql.org; Mon, 24 Aug 2015 11:44:25 +0000 Received: from relay4-d.mail.gandi.net ([2001:4b98:c:538::196]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZTqAo-0001PP-E9 for pgsql-performance@postgresql.org; Mon, 24 Aug 2015 11:44:24 +0000 Received: from mfilter21-d.gandi.net (mfilter21-d.gandi.net [217.70.178.149]) by relay4-d.mail.gandi.net (Postfix) with ESMTP id EEADD172074; Mon, 24 Aug 2015 13:44:20 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mfilter21-d.gandi.net Received: from relay4-d.mail.gandi.net ([IPv6:::ffff:217.70.183.196]) by mfilter21-d.gandi.net (mfilter21-d.gandi.net [::ffff:10.0.15.180]) (amavisd-new, port 10024) with ESMTP id 8GjVSu0IqvCk; Mon, 24 Aug 2015 13:44:19 +0200 (CEST) X-Originating-IP: 98.122.164.227 Received: from [192.168.10.146] (unknown [98.122.164.227]) (Authenticated sender: adsend@dunslane.net) by relay4-d.mail.gandi.net (Postfix) with ESMTPSA id 3647B172097; Mon, 24 Aug 2015 13:44:18 +0200 (CEST) Subject: Re: problem with select * To: bhuvan Mitra , pgsql-performance@postgresql.org References: From: Andrew Dunstan Message-ID: <55DB0391.7090004@dunslane.net> Date: Mon, 24 Aug 2015 07:44:17 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.1.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 08/24/2015 03:04 AM, bhuvan Mitra wrote: > Hello, > > I have a table with 12 columns and 20 Million rows. While writing the > table I do not find any problem but when reading that I have some > issues faced. When I perform a 'select * from table limit 14000000;' > (selecting 14million rows), it is working fine. If the limit value is > 15000000, it is throwing the error as 'out of memory'. > > If the query is 'select * from table' , The process is getting killed > by displaying the message 'killed'. > > Kindly tell me where it is going wrong. I have 6MB cache, 1.6GHz CPU, > linux 14.04 OS, 8GB RAM. > > You should be using a cursor. cheers andrew -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance