RE: Ran out of memory retrieving query results.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

RE: Ran out of memory retrieving query results.

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.

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



-----Original Message-----
From: Stephen Frost [mailto:[hidden email]]
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 [hidden email] with your question, this address is for the moderators.

Thanks!

Stephen

* Nanda Kumar ([hidden email]) 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
>
> [hidden email] | 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. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or 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. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

Reply | Threaded
Open this post in threaded view
|

Re: Ran out of memory retrieving query results.

Andreas Kretschmer-3


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