Re: [HACKERS] Reusing Dead Tuples:

2002-12-18 Thread Janardhan
Tom Lane wrote: Janardhan <[EMAIL PROTECTED]> writes: Does it breaks any other things if all the index entries pointing the dead tuple are removed before reusing the dead tuple?. Possibly you could make that work, but I think you'll find the efficiency ad

Re: [HACKERS] Big 7.4 items

2002-12-16 Thread Janardhan
The  file  "ftp://candle.pha.pa.us/pub/postgresql/PITR_20020822_02.gz" do not have read permissions to copy. please provide the read permissions to copy. Regards jana Patrick Macdonald wrote: Bruce Momjian wrote: I wanted to outline some of the big items we are loo

Re: [HACKERS] Reusing Dead Tuples:

2002-12-12 Thread Janardhan
Tom Lane wrote: Janardhan <[EMAIL PROTECTED]> 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 hoop

Re: [HACKERS] Reusing Dead Tuples:

2002-12-10 Thread Janardhan
Tom Lane wrote: Janardhan <[EMAIL PROTECTED]> 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 hoop

[HACKERS] Reusing Dead Tuples:

2002-12-10 Thread Janardhan
Hi, I am doing some experiments on dead tuples, I am looking of reusing the dead tuples apace in a particular page during the "Update".This patch is meant for the tables which are heavily updated to avoid vacuum very frequently.By using it will arrest the size of table for heavily updated ta