Re: Extreme bloating of intarray GiST indexes
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>, postgres hackers <pgsql-hackers@postgresql.org>
Date: 2011-04-28T21:27:29Z
Lists: pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes: > What opclass is used for GiST index: gist__int_ops or gist__intbig_ops? > Do you take into account that gist__int_ops is very inefficient for large > datasets? I seem to recall some discussion recently about documenting where you should cut over to using "gist__intbig_ops" --- IIRC, it wasn't all that "big" by modern standards. But it doesn't look like any such change made it into the docs. Should we reopen that discussion? regards, tom lane