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

Re: BUG #4410: Indexes not seen right away

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: BUG #4410: Indexes not seen right away
Date: 2008-10-06 07:59:35
Message-ID: 48E9C567.408@hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-docs
Greg Sabino Mullane wrote:
> 
>>>> 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>."

I think putting links in the user documentation directly to development
README files that require you to look in the source code is a bad thing...


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

If we want the full explanation there, that's how it should be done :-)

//Magnus

In response to

pgsql-docs by date

Next:From: postgres Emanuel CALVO FRANCODate: 2008-10-28 15:33:10
Subject: FAQ_Solaris 1.28 to spanish
Previous:From: Greg Sabino MullaneDate: 2008-10-05 21:59:48
Subject: Re: BUG #4410: Indexes not seen right away

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2008-10-06 08:03:23
Subject: Re: BUG #4451: initcap() function capitalizes incorrectly
Previous:From: Jeff DavisDate: 2008-10-06 07:03:40
Subject: index bloat in 8.4-dev

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