Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0067237C9E3; Sun, 5 Oct 2008 18:59:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 72572-06; Sun, 5 Oct 2008 18:59:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tinlc.com (unknown [72.18.206.65]) by postgresql.org (Postfix) with ESMTP id 6626637C9CD; Sun, 5 Oct 2008 18:59:54 -0300 (ADT) Received: from biglumber.com ([72.18.206.64] helo=localhost) by tinlc.com with smtp (Exim 4.60) (envelope-from ) id 1Kmbdk-0004CW-TH; Sun, 05 Oct 2008 16:59:48 -0500 From: "Greg Sabino Mullane" To: pgsql-bugs@postgresql.org Cc: pgsql-docs@postgresql.org CC: pgsql-docs@postgresql.org Subject: Re: BUG #4410: Indexes not seen right away X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <200810022107.m92L7nh25041@momjian.us> Date: Sun, 5 Oct 2008 21:59:48 -0000 X-Mailer: JoyMail 2.01 Message-ID: <7b98830a9fbba455fa905b3ca0ef8231@biglumber.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200810/11 X-Sequence-Number: 21486 -----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 ." 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-----