Re: Out of Memory

On 1/15/2015 3:17 PM, Enrico Bianchi wrote:
> When I launch a query (the principal field is JSONb), the database
> return this:
>
> ERROR:  out of memory
> DETAIL:  Failed on request of size 110558.

it looks like your query is trying to return 7 million rows, although
you didn't do EXPLAIN ANALYZE, so your query plan statistics are all
estimates.      without knowing your schema and table contents its hard
to say more.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast