Thread: problem with select *

problem with select *

From
bhuvan Mitra
Date:
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.

Thanks.

Re: problem with select *

From
Wei Shan
Date:
Hi,

Please share with us on the configuration in postgresql.conf

Thanks!

On 24 August 2015 at 15:04, bhuvan Mitra <bhuvanrjb@gmail.com> 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.

Thanks.



--
Regards,
Ang Wei Shan

Re: problem with select *

From
Andreas Joseph Krogh
Date:
På mandag 24. august 2015 kl. 09:04:07, skrev bhuvan Mitra <bhuvanrjb@gmail.com>:
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.
 
In what application are you performing these queries?
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

Re: problem with select *

From
Andrew Dunstan
Date:

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