Hi, Please share with us on the configuration in postgresql.conf
Thanks! On 24 August 2015 at 15:04, bhuvan Mitra <bhuvan...@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