HOT and INSERT/DELETE

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Pavan Deolasee <pavan(at)enterprisedb(dot)com>
Subject: HOT and INSERT/DELETE
Date: 2007-08-09 00:57:53
Message-ID: 200708090057.l790vrx22836@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-08-09 01:07:15 Re: default_text_search_config and expression indexes
Previous Message ITAGAKI Takahiro 2007-08-09 00:57:48 Re: GUC for default heap fillfactor