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(dot)kumar(at)smartstream-stp(dot)com | www.smartstream-stp.com
Mob
+91 99720 44779
Tel
+91 80617 64107

-----Original Message-----
From: Stephen Frost [mailto:sfrost(at)snowman(dot)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(at)lists(dot)postgresql(dot)org with your question, this address is for the moderators.

Thanks!

Stephen

* Nanda Kumar (Nanda(dot)Kumar(at)smartstream-stp(dot)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(dot)png(at)01D4D5AA(dot)5A204D50]
>
>
>
> Regards
>
> Nanda Kumar.M
>
> SmartStream Technologies
>
> Eastland Citadel | 5th Floor | 102 Hosur Road | Banglore 560 095 |
> India
>
> nanda(dot)kumar(at)smartstream-stp(dot)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. 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.