Re: optimize lookups in snapshot [sub]xip arrays

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
Re: optimize lookups in snapshot [sub]xip arrays
Дата
Msg-id
20220806181326.GA1216305@nathanxps13
Ответ на
Список
Дерево обсуждения
optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Masahiko Sawada <sawada.mshk@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Masahiko Sawada <sawada.mshk@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Tom Lane <tgl@sss.pgh.pa.us>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Zhang Mingli <zmlpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Yura Sokolov <y.sokolov@postgrespro.ru>
Re: optimize lookups in snapshot [sub]xip arrays Zhang Mingli <zmlpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Zhang Mingli <zmlpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
On Fri, Aug 05, 2022 at 03:04:34PM -0700, Andres Freund wrote:
> But mainly I'd expect to find a difference if the SIMD code were optimized a
> further on the basis of not needing to return the offset. E.g. by
> replacing _mm_packs_epi32 with _mm_or_si128, that's cheaper.

I haven't been able to find a significant difference between the two.  If
anything, the _mm_packs_epi* approach actually seems to be slightly faster
in some cases.  For something marginally more concrete, I compared the two
in perf-top and saw the following for the relevant instructions:

_mm_packs_epi*:
	0.19 │       packssdw   %xmm1,%xmm0
	0.62 │       packssdw   %xmm1,%xmm0
	7.14 │       packsswb   %xmm1,%xmm0

_mm_or_si128:
	1.52 │       por        %xmm1,%xmm0
	2.05 │       por        %xmm1,%xmm0
	5.66 │       por        %xmm1,%xmm0

I also tried a combined approach where I replaced _mm_packs_epi16 with
_mm_or_si128:
	1.16 │       packssdw   %xmm1,%xmm0
	1.47 │       packssdw   %xmm1,%xmm0
	8.17 │       por        %xmm1,%xmm0

Of course, this simplistic analysis leaves out the impact of the
surrounding instructions, but it seems to support the idea that the
_mm_packs_epi* approach might have a slight edge.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Peter Geoghegan
Дата:
FAQ