Re: BUG #4410: Indexes not seen right away - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Re: BUG #4410: Indexes not seen right away
Date
Msg-id 7b98830a9fbba455fa905b3ca0ef8231@biglumber.com
Whole thread Raw
In response to Re: BUG #4410: Indexes not seen right away  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #4410: Indexes not seen right away  (Magnus Hagander <magnus@hagander.net>)
List pgsql-bugs
-----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@turnstep.com
PGP Key: 0x14964AC8 200810051758
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

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



pgsql-bugs by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: BUG #4450: Postgres do not ask for passord
Next
From: "Gurjeet Singh"
Date:
Subject: Re: BUG #4450: Postgres do not ask for passord