Re: Reusing Dead Tuples:

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

Tom Lane wrote:

>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
>
>
>
Does it breaks any other things if all the index entries pointing the
dead tuple are removed before reusing the dead tuple?.

Regards
jana

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2002-12-13 07:31:38 Re: Creating a zero-column table
Previous Message Shridhar Daithankar 2002-12-13 07:05:05 Re: Big 7.4 items