Re: Where to find information on the new HOT tables?

On Tue, 5 Feb 2008 23:13:59 +0100
Dimitri Fontaine <dfontaine@hi-media.com> wrote:

> Le Tuesday 05 February 2008 22:35:11 Tom Lane, vous avez écrit :
> > The reason there isn't one is it doesn't need one; it's an
> > implementation detail not a user-visible feature. ,

Although it is an implementation detail it is certainly a very
user-visible detail. It can and will affect how people design their
databases to take advantage of the implementation detail.

>
> So how do you want us to handle the users questions about how HOT is
> good for them and who'd like to have some insights of its inner
> working, but don't want to properly learn the internals of PostgreSQL
> implementation?

We need to write a one page mini-HOWTO on taking advantage of HOT and
HOTs limitations.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit