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