Re: [HACKERS] [PATCH] SortSupport for macaddr type - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: [HACKERS] [PATCH] SortSupport for macaddr type
Date
Msg-id 0be5a36c-6492-538e-5057-b8a37e948f95@iki.fi
Whole thread Raw
In response to Re: [HACKERS] [PATCH] SortSupport for macaddr type  (Neha Khatri <nehakhatri5@gmail.com>)
Responses Re: [HACKERS] [PATCH] SortSupport for macaddr type  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Looks straightforward at a quick read-through. I have just a couple of 
questions. How much of the performance gain comes from avoiding the 
FunctionCallInvoke overhead, by simply having SortSupport with a 
comparison function, and how much comes from the "abbreviation"?

Also, is it worth the cycles and code to have the hyperloglog estimator, 
and aborting the abbreviation if there are only a few distinct values. 
Or put another way, how much does the abbreviation slow things down in 
the worst case?

- Heikki




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [HACKERS] scram and \password
Next
From: David Rowley
Date:
Subject: Re: [HACKERS] multivariate statistics (v25)