Обсуждение: RE: Ran out of memory retrieving query results.

Hello Tem,

Can you please help on the below issues . The below Error occurred when I run the select statement for the huge data
volume.

 Error Details :

 Ran out of memory retrieving query results.

Regards
Nanda Kumar.M
SmartStream Technologies
Eastland Citadel | 5th Floor | 102 Hosur Road | Banglore 560 095 | India
nanda.kumar@smartstream-stp.com | www.smartstream-stp.com
Mob
+91 99720 44779
Tel
+91 80617 64107



-----Original Message-----
From: Stephen Frost [mailto:sfrost@snowman.net]
Sent: 09 March 2019 00:19
To: Nanda Kumar
Cc: pgsql-general Owner
Subject: Re: Ran out of memory retrieving query results.

Greetings,

You need to email pgsql-general@lists.postgresql.org with your question, this address is for the moderators.

Thanks!

Stephen

* Nanda Kumar (Nanda.Kumar@smartstream-stp.com) wrote:
> Hello Team,
>
>
>
> I am getting error when I try to run the select query. Kindly help me in fixing this issue.
>
>
>
> Error Details :
>
>
>
> Ran out of memory retrieving query results.
>
>
>
> Screenshot of the error :
>
>
>
> [cid:image001.png@01D4D5AA.5A204D50]
>
>
>
> Regards
>
> Nanda Kumar.M
>
> SmartStream Technologies
>
> Eastland Citadel | 5th Floor | 102 Hosur Road | Banglore 560 095 |
> India
>
> nanda.kumar@smartstream-stp.com | www.smartstream-stp.com
>
> Mob +91 99720 44779
>
> ________________________________
> The information in this email is confidential and may be legally privileged. It is intended solely for the addressee.
Accessto this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying,
distributionor any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 


________________________________
 The information in this email is confidential and may be legally privileged. It is intended solely for the addressee.
Accessto this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying,
distributionor any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 

Am 11.03.19 um 06:44 schrieb Nanda Kumar:
> Hello Tem,
>
> Can you please help on the below issues . The below Error occurred when I run the select statement for the huge data
volume.
>
>   Error Details :
>
>   Ran out of memory retrieving query results.

you should provide more details, for instance (at least)
* os and pg version
* how much ram contains the machine
* config-parameters (shared_buffers, work_mem, max_connections)
* running activities
* the query itself
* table-definition
* how large are the tables
* the EXPLAIN of the query


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com