Re: Getting PGRES_FATAL_ERROR - out of memory for query result in PostgreSQL DB

Newsgroups	pgsql.general
Date	2016-12-27 10:18 -0800
References	<dcd77ee9-0e9a-4d7f-92f1-839643445847@googlegroups.com>
Message-ID	<b62ddf97-45f3-47d8-a718-d824d08da81c@googlegroups.com> (permalink)
Subject	Re: Getting PGRES_FATAL_ERROR - out of memory for query result in PostgreSQL DB
From	Paulo Moraes <paulomoraesdba@gmail.com>

Show all headers | View raw

Em quarta-feira, 20 de julho de 2016 10:42:49 UTC-3, bharad...@gmail.com  escreveu:
> 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

Hello,
Try to increase the size of parameter :
shared_buffer on postgres.conf

Back to pgsql.general | Previous | Next — Previous in thread | Find similar

Thread

Getting PGRES_FATAL_ERROR - out of memory for query result in PostgreSQL DB bharadwajj19@gmail.com - 2016-07-20 06:42 -0700
  Re: Getting PGRES_FATAL_ERROR - out of memory for query result in PostgreSQL DB Paulo Moraes <paulomoraesdba@gmail.com> - 2016-12-27 10:18 -0800

csiph-web