Re: problem with select *
От
Andrew Dunstan
Тема
Re: problem with select *
Дата
Msg-id
55DB0391.7090004@dunslane.net
Ответ на
problem with select * (bhuvan Mitra)
Список
Дерево обсуждения
problem with select * bhuvan Mitra <bhuvanrjb@gmail.com>
Re: problem with select * Andrew Dunstan <andrew@dunslane.net>
Re: problem with select * Wei Shan <weishan.ang@gmail.com>
Re: problem with select * Andreas Joseph Krogh <andreas@visena.com>
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
В списке pgsql-performance по дате отправления
