Re: [HACKERS] HOT and INSERT/DELETE

2007-08-08 Thread Bruce Momjian
Pavan Deolasee wrote: > On 8/9/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > 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 w

Re: [HACKERS] HOT and INSERT/DELETE

2007-08-08 Thread Pavan Deolasee
On 8/9/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > 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. As t

[HACKERS] HOT and INSERT/DELETE

2007-08-08 Thread Bruce Momjian
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 r