From: | Wei Shan <weishan(dot)ang(at)gmail(dot)com> |
---|---|
To: | bhuvan Mitra <bhuvanrjb(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: problem with select * |
Date: | 2015-08-24 07:13:42 |
Message-ID: | CAFe9ZTqVZoC5Pc5ry-kSx3ohYMpXDC5sF=pNnUkvgZiF+cr1aA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
Please share with us on the configuration in postgresql.conf
Thanks!
On 24 August 2015 at 15:04, bhuvan Mitra <bhuvanrjb(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2015-08-24 08:59:11 | Re: problem with select * |
Previous Message | bhuvan Mitra | 2015-08-24 07:04:07 | problem with select * |