Re: Out of Memory

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory
Date: 2015-01-16 00:19:52
Message-ID: 54B85928.6030401@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-01-16 00:30:26 Re: can you have any idea about toast missing chunk issu resolution
Previous Message Nathan Clayton 2015-01-16 00:18:40 Re: Indexing large table of coordinates with GiST