Re: range_agg - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: range_agg
Date
Msg-id 20200404231018.GA4570@alvherre.pgsql
Whole thread Raw
In response to Re: range_agg  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: range_agg
Re: range_agg
List pgsql-hackers
On 2020-Mar-23, Paul Jungwirth wrote:

> On Mon, Mar 23, 2020 at 4:33 PM Alvaro Herrera <alvherre@2ndquadrant.com>
> wrote:
> >
> > Thinking about the on-disk representation, can we do better than putting
> > the contained ranges in long-varlena format, including padding; also we
> > include the type OID with each element.  Sounds wasteful.  A more
> > compact representation might be to allow short varlenas and doing away
> > with the alignment padding, put the the type OID just once.  This is
> > important because we cannot change it later.
> 
> Can you give me some guidance on this? I don't know how to make the on-disk
> format different from the in-memory format. (And for the in-memory format, I
> think it's important to have actual RangeTypes inside the multirange.) Is
> there something in the documentation, or a README in the repo, or even
> another type I can follow?

Sorry I didn't reply earlier, but I didn't know the answer then and I
still don't know the answer now.

Anyway, I rebased this to verify that the code hasn't broken, and it
hasn't -- the tests still pass.  There was a minor conflict in
pg_operator.dat which I fixed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Should we add xid_current() or a int8->xid cast?
Next
From: Thomas Munro
Date:
Subject: Re: Should we add xid_current() or a int8->xid cast?