Re: [BUGS] BUG #4410: Indexes not seen right away

["Greg Sabino Mullane" <greg(at)turnstep(dot)com>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> > > Does it have pg_index.indcheckxmin = true?  If so, see README.HOT.
>
>> Yes, that was probably it. Is this worth noting in the documentation somewhere
>> (other than the technical bowels of HOT)? Perhaps in the CREATE INDEX
>> docs?
...
> I have attached the scripts I used for testing.  I don't think it is
> worth documenting this until we have 8.4 released and people start using
> it.

I'm not following this, Bruce. HOT came out in 8.3, not 8.4, so why would we
wait on documenting the problem?

> I believe a mention in the manual would require quite complex wording.

Seems something would be better than nothing. Example:

"Note: In versions 8.3 and higher, indexes may not be immediately visible
due to the way HOT chains work. For more information, please see
<link to README.HOT>."

It might be nice to upgrade README.HOT to a real documentation page
as well.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200810051758
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkjpOKkACgkQvJuQZxSWSshJ/QCgzeTdyP7tEZnYc+4GZZhyTPJ2
8IQAoJDmkbBDdGYlUoF7W3pcJSNvInW6
=aStx
-----END PGP SIGNATURE-----