Re: [HACKERS] Small GIN optimizations (after 9.4)

2014-02-11 Thread Alexander Korotkov
On Wed, Feb 12, 2014 at 2:58 AM, Bruce Momjian wrote: > On Sun, Feb 9, 2014 at 02:17:12PM +0400, Alexander Korotkov wrote: > > On Thu, Feb 6, 2014 at 8:31 PM, PostgreSQL - Hans-J rgen Sch nig < > > postg...@cybertec.at> wrote: > > > > i think there is one more thing which would be really goo

Re: [HACKERS] Small GIN optimizations (after 9.4)

2014-02-11 Thread Bruce Momjian
On Sun, Feb 9, 2014 at 02:17:12PM +0400, Alexander Korotkov wrote: > On Thu, Feb 6, 2014 at 8:31 PM, PostgreSQL - Hans-J rgen Sch nig < > postg...@cybertec.at> wrote: > > i think there is one more thing which would be really good in GIN and > which > would solve a ton of issues. > at

Re: [HACKERS] Small GIN optimizations (after 9.4)

2014-02-09 Thread Alexander Korotkov
On Thu, Feb 6, 2014 at 3:36 PM, Heikki Linnakangas wrote: > While hacking on the GIN patches, I've come up with a few different ideas > for improving performance. It's too late for 9.4, but I'll list them here > if someone wants to work on them later: > > * Represent ItemPointers as uint64's, to s

Re: [HACKERS] Small GIN optimizations (after 9.4)

2014-02-09 Thread Alexander Korotkov
On Thu, Feb 6, 2014 at 8:31 PM, PostgreSQL - Hans-Jürgen Schönig < postg...@cybertec.at> wrote: > i think there is one more thing which would be really good in GIN and > which would solve a ton of issues. > atm GIN entries are sorted by item pointer. > if we could sort them by a "column" it would

Re: [HACKERS] Small GIN optimizations (after 9.4)

2014-02-06 Thread PostgreSQL - Hans-Jürgen Schönig
i think there is one more thing which would be really good in GIN and which would solve a ton of issues. atm GIN entries are sorted by item pointer. if we could sort them by a "column" it would fix a couple of real work issues such as ... SELECT ... FROM foo WHERE "tsearch_query" ORDER B

[HACKERS] Small GIN optimizations (after 9.4)

2014-02-06 Thread Heikki Linnakangas
While hacking on the GIN patches, I've come up with a few different ideas for improving performance. It's too late for 9.4, but I'll list them here if someone wants to work on them later: * Represent ItemPointers as uint64's, to speed up comparisons. ginCompareItemPointers is inlined into only