Re: Out of Memory - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of Memory
Date
Msg-id 3681.1421371129@sss.pgh.pa.us
Whole thread Raw
In response to Out of Memory  (Enrico Bianchi <enrico.bianchi@ymail.com>)
Responses Re: Out of Memory  (Enrico Bianchi <enrico.bianchi@ymail.com>)
List pgsql-general
Enrico Bianchi <enrico.bianchi@ymail.com> writes:
> 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.

That error should be associated with a memory usage map getting dumped to
postmaster stderr, where hopefully your logging setup will catch it.
Can we see the map?

Even better would be a self-contained test case.  Maybe you can generate
some artificial data that produces the problem?

            regards, tom lane


pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Need advice for handling big data in postgres
Next
From: Jim Nasby
Date:
Subject: Re: Proper use of pg_xlog_location_diff()