Re: "unaddressable bytes" in BRIN

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "unaddressable bytes" in BRIN
Date: 2015-05-11 12:32:02
Message-ID: 20150511123202.GV30322@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Alvaro Herrera (alvherre(at)2ndquadrant(dot)com) wrote:
> What I think this means is that during an index build
> brin_minmax_add_value() called numeric_lt() which detoasted one of its
> input values; later, brin_doinsert() inserts a tuple containing the
> value, but it tries to use more bytes than were allocated. I haven't
> had time to actually study what is going on here, but wanted to archive
> this publicly. (Value detoasting evidently plays a role here, but I
> don't know how.)

I went ahead and added this to the 9.5 open items list.

Thanks!

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2015-05-11 13:00:55 Re: EvalPlanQual behaves oddly for FDW queries involving system columns
Previous Message Robert Haas 2015-05-11 12:29:05 Re: multixacts woes