| 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: | Whole Thread | Raw Message | 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
| 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 |