Re: HOT is applied - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: HOT is applied
Date
Msg-id 2e78013d0709201959x7c14a61fkf6ae812b9e4dd5c8@mail.gmail.com
Whole thread Raw
In response to Re: HOT is applied  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: HOT is applied
List pgsql-hackers


On 9/21/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Shouldn't we be able to prune rows that have been inserted and deleted
by the same transaction?  I'd have hoped to see this example use only
one heap page ...


Not before the transaction commits ? In the test, we update a single tuple
10000 times in the same transaction. So there is no opportunity to prune.

Thanks,
Pavan


--
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: HOT is applied
Next
From: Tom Lane
Date:
Subject: Re: HOT is applied