Re: Out of Memory - Mailing list pgsql-general

From John R Pierce
Subject Re: Out of Memory
Date
Msg-id 54B85928.6030401@hogranch.com
Whole thread Raw
In response to Out of Memory  (Enrico Bianchi <enrico.bianchi@ymail.com>)
Responses Re: Out of Memory
List pgsql-general
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



pgsql-general by date:

Previous
From: Nathan Clayton
Date:
Subject: Re: Indexing large table of coordinates with GiST
Next
From: Jim Nasby
Date:
Subject: Re: [HACKERS] can you have any idea about toast missing chunk issu resolution