HOT and INSERT/DELETE - Mailing list pgsql-hackers

From Bruce Momjian
Subject HOT and INSERT/DELETE
Date
Msg-id 200708090057.l790vrx22836@momjian.us
Whole thread Raw
In response to Re: HOT patch, missing things  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: HOT and INSERT/DELETE  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-hackers
I was wondering about HOT behavior.

Will an INSERT reuse rows no longer visible caused by an UPDATE or
DELETE, or if an UPDATE will reuse rows expired by an invisible DELETE? 
It seems both of these would be possible and useful.

My basic question is HOT UPDATE-only in both operation and expired row
reuse?

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: GUC for default heap fillfactor
Next
From: Bruce Momjian
Date:
Subject: Re: default_text_search_config and expression indexes