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