Re: Reusing Dead Tuples:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Janardhan <jana-reddy(at)mediaring(dot)com(dot)sg>
Cc: PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reusing Dead Tuples:
Date: 2002-12-11 04:35:35
Message-ID: 8875.1039581335@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Janardhan <jana-reddy(at)mediaring(dot)com(dot)sg> writes:
> Does it breaks anythings by overwriting the dead tuples ?.

Yes. You cannot do that unless you've first removed index entries
pointing at the dead tuples --- and jumped through the same locking
hoops that lazy vacuum does while removing index entries.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-12-11 04:37:18 Re: [HACKERS] GEQO Triggers Server Crash
Previous Message Bruce Momjian 2002-12-11 04:15:36 Re: Problems with ALTER DOMAIN patch