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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Chris Hoover <revoohc(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: Where to find information on the new HOT tables?
Date: 2008-02-05 22:25:35
Message-ID: 20080205142535.12e5c28e@jd-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 5 Feb 2008 23:13:59 +0100
Dimitri Fontaine <dfontaine(at)hi-media(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-02-05 22:57:31 Re: Where to find information on the new HOT tables?
Previous Message Dimitri Fontaine 2008-02-05 22:13:59 Re: Where to find information on the new HOT tables?