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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
