Re: Optimizing pg_trgm makesign() (was Re: WIP: Fast GiST index build)
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Alexander Korotkov <aekorotkov@gmail.com>
Date: 2011-07-02T18:46:10Z
Lists: pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes: > Ah, that opens the door to do something I considered earlier but > rejected because of alignment: instead of three 32-bit word fetches, we > could fetch one 64-bit word and 32-bit word. Might shave a few more > cycles... Hm ... I suspect that might be a small win on natively-64-bit machines, but almost certainly a loss on 32-bitters. > Meanwhile, I experimented with optimizing the other part of the loop: > the HASH() macros for setting the right bits in the signature. Yeah, I was eyeing that too, but I'm hesitant to hard-wire assumptions about the size of the signature. regards, tom lane