Re: Spilling hashed SetOps and aggregates to disk - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Spilling hashed SetOps and aggregates to disk
Date
Msg-id 9584.1528739975@sss.pgh.pa.us
Whole thread Raw
In response to Re: Spilling hashed SetOps and aggregates to disk  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> Also, I am not sure we should really be designing around data types
> where it makes sense to group and then don't supply a btree opclass.
> Seems like they are likely to hit a problem soon anyway.

It's not that unreasonable to have a hash opclass and no btree opclass;
the datatype might not have a natural linear ordering.

But in any case, I think Robert's point was that he'd prefer to avoid
having a poorly-tested special-case code path for that situation, which
seems like a good idea independently of performance considerations.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Spilling hashed SetOps and aggregates to disk
Next
From: Jeff Davis
Date:
Subject: Re: Spilling hashed SetOps and aggregates to disk