From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | bhuvan Mitra <bhuvanrjb(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: problem with select * |
Date: | 2015-08-24 11:44:17 |
Message-ID: | 55DB0391.7090004@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guo, Yun | 2015-08-24 14:45:16 | Re: query not using GIN index |
Previous Message | Genc | 2015-08-24 10:22:27 | Re: Performance bottleneck due to array manipulation |