Re: Interesting glitch in autovacuum

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Interesting glitch in autovacuum
Date: 2008-09-10 18:10:20
Message-ID: 48C80D8C.3050301@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera wrote:
> I didn't know we were doing HOT pruning during vacuum; does
> it make sense?

Removing HOT-updated, dead tuples is a bit complicated. It needs to be
done one HOT-chain at a time, and the root line pointer needs to be
updated to the next live tuple in the chain. lazy_scan_heap() calls the
regular pruning function heap_page_prune() to deal with those before
doing the normal scan of line pointers.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-09-10 18:17:37 Re: Synchronous Log Shipping Replication
Previous Message Tom Lane 2008-09-10 17:57:11 Re: Interesting glitch in autovacuum