pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem with select *
4+ messages / 4 participants
[nested] [flat]
* problem with select *
@ 2015-08-24 07:04 bhuvan Mitra <bhuvanrjb@gmail.com>
2015-08-24 07:13 ` Re: problem with select * Wei Shan <weishan.ang@gmail.com>
2015-08-24 08:59 ` Re: problem with select * Andreas Joseph Krogh <andreas@visena.com>
2015-08-24 11:44 ` Re: problem with select * Andrew Dunstan <andrew@dunslane.net>
0 siblings, 3 replies; 4+ messages in thread
From: bhuvan Mitra @ 2015-08-24 07:04 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problem with select *
2015-08-24 07:04 problem with select * bhuvan Mitra <bhuvanrjb@gmail.com>
@ 2015-08-24 07:13 ` Wei Shan <weishan.ang@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Wei Shan @ 2015-08-24 07:13 UTC (permalink / raw)
To: bhuvan Mitra <bhuvanrjb@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problem with select *
2015-08-24 07:04 problem with select * bhuvan Mitra <bhuvanrjb@gmail.com>
@ 2015-08-24 08:59 ` Andreas Joseph Krogh <andreas@visena.com>
2 siblings, 0 replies; 4+ messages in thread
From: Andreas Joseph Krogh @ 2015-08-24 08:59 UTC (permalink / raw)
To: pgsql-performance
På mandag 24. august 2015 kl. 09:04:07, skrev bhuvan Mitra <bhuvanrjb@gmail.com
<mailto: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
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
<https://www.visena.com;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: problem with select *
2015-08-24 07:04 problem with select * bhuvan Mitra <bhuvanrjb@gmail.com>
@ 2015-08-24 11:44 ` Andrew Dunstan <andrew@dunslane.net>
2 siblings, 0 replies; 4+ messages in thread
From: Andrew Dunstan @ 2015-08-24 11:44 UTC (permalink / raw)
To: bhuvan Mitra <bhuvanrjb@gmail.com>; 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2015-08-24 11:44 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-08-24 07:04 problem with select * bhuvan Mitra <bhuvanrjb@gmail.com>
2015-08-24 07:13 ` Wei Shan <weishan.ang@gmail.com>
2015-08-24 08:59 ` Andreas Joseph Krogh <andreas@visena.com>
2015-08-24 11:44 ` Andrew Dunstan <andrew@dunslane.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox