Re: To Do wiki

On 10.04.2012 18:31, Jeff Janes wrote:
> On Mon, Apr 9, 2012 at 11:27 PM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>> On 10.04.2012 03:32, Jeff Janes wrote:
>>>
>>> The To Do wiki says not to add things to the page with discussing here.
> ...
>>
>>> sort_support was implemented for plain tuple sorting only, To Do is
>>> extend to index-creation sorts (item 2 from message
>>> <1698(dot)1323222387(at)sss(dot)pgh(dot)pa(dot)us>)
>>
>> Index-creation sorts are already handled, Tom is referring to using the new
>> comparator API for index searches in that email. The change would go to
>> _bt_compare().
>
> If I do "select count(distinct bid) from pgbench_accounts" I get many
> calls to btint4fastcmp, but if I do "create index on pgbench_accounts
> (bid)" I instead get many calls to btint4cmp. If the index build is
> using SortSupport, shouldn't it also be calling btint4fastcmp like the
> distinct does?

Oh, sorry, you're right. I stand corrected.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com