info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Getting PGRES_FATAL_ERROR - out of memory for query result in PostgreSQL DB
27 views
Skip to first unread message
bharad...@gmail.com
Jul 20, 2016, 9:42:49 AM7/20/16
to
I have fired one query in PostgreSQL , which outcome should have 2207 rows and 8 columns(having integer and string and bytea type of data). But I am unable to get the result.
By PQexec(), PQresultStatus() and PQresultErrorMessage(), I am able to get that it is PGRES_FATAL_ERROR - out of memory for query result error.
But I am still looking for the reason why it came in our environment as fired query's outcome doesn't seem has a large data. So why is it getting out of memory for query result error
By PQexec(), PQresultStatus() and PQresultErrorMessage(), I am able to get that it is PGRES_FATAL_ERROR - out of memory for query result error.
But I am still looking for the reason why it came in our environment as fired query's outcome doesn't seem has a large data. So why is it getting out of memory for query result error
Paulo Moraes
Dec 27, 2016, 1:18:04 PM12/27/16
to
Try to increase the size of parameter :
shared_buffer on postgres.conf
0 new messages