Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-docs by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group