Re: FPI

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FPI
Date: 2011-01-28 19:11:52
Message-ID: AANLkTi=Jm=p256etktLcPjNnYEgCHQMoJVZSUhYtK2ii@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 28, 2011 at 1:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> On Fri, Jan 28, 2011 at 10:13 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Say what?  A heap deletion compacts the page --- it will certainly fail
>>> badly on torn-page.
>
>> What do you mean by "compacts the page"?  I would interpret that to
>> mean "reclaims the space formerly used by the tuple being deleted",
>> but it certainly can't do that.
>
> Oh, I'm sorry, I was confusing the case with vacuum cleanup.  Obviously
> hadn't consumed any caffeine yet.  Nevermind ...

OK. You had me worried for a minute there. :-)

Any substantive comments, besides the obvious "this is not 9.1 material"?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

  • Re: FPI at 2011-01-28 18:42:43 from Tom Lane

Responses

  • Re: FPI at 2011-01-28 20:08:44 from Tom Lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2011-01-28 19:12:05 mingw format warnings
Previous Message Robert Haas 2011-01-28 19:09:15 Re: Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql