Re: BUG #4410: Indexes not seen right away

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: BUG #4410: Indexes not seen right away
Date: 2008-10-05 21:59:48
Message-ID: 7b98830a9fbba455fa905b3ca0ef8231@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs


-----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-----

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gurjeet Singh 2008-10-05 22:59:05 Re: BUG #4450: Postgres do not ask for passord
Previous Message tomas 2008-10-05 16:36:52 Re: BUG #4450: Postgres do not ask for passord

Browse pgsql-docs by date

  From Date Subject
Next Message Magnus Hagander 2008-10-06 07:59:35 Re: BUG #4410: Indexes not seen right away
Previous Message Bruce Momjian 2008-10-02 21:07:49 Re: BUG #4410: Indexes not seen right away