From: Bruce Momjian <bruce@momjian.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Dimitri Fontaine <dfontaine@hi-media.com>
Cc: pgsql-admin@postgresql.org, Chris Hoover <revoohc@gmail.com>
Subject: Re: Where to find information on the new HOT tables?
Date: Fri, 8 Feb 2008 11:00:08 -0500 (EST)
Message-ID: <200802081600.m18G08629377@momjian.us> (raw)
In-Reply-To: <20080207234844.GH23336@alvh.no-ip.org>
Alvaro Herrera wrote:
> Bruce Momjian escribi?:
> > Dimitri Fontaine wrote:
>
> > > What about Alvaro's concern about manual vacuuming policies editing wrt to
> > > HOT?
> >
> > I think most people will be using autovacuum, and those who aren't will
> > have to realize that HOT makes vacuuming less needed.
>
> Hmm, and how will they realize it, if they don't understand how HOT
> comes into the equation?
Well, since this is a change in the behavior of this release, and not
something that will change over time, perhaps we need a sentence in
there about vacuuming changes.
The release note item says we can now reclaim without vacuum:
"UPDATE"s and "DELETE"s leave dead tuples behind, as do failed
"INSERT"s. Previously only "VACUUM" could reclaim
space taken by dead tuples. With HOT dead tuple space can be
automatically reclaimed at the time of "INSERT" or ...
so it seems logical that the need to vacuum would change. We can add
an explicit sentence about that to the release notes.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, alvherre@commandprompt.com, dfontaine@hi-media.com, revoohc@gmail.com
Subject: Re: Where to find information on the new HOT tables?
In-Reply-To: <200802081600.m18G08629377@momjian.us>
References: <20080207234844.GH23336@alvh.no-ip.org> <200802081600.m18G08629377@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox