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
