btree shrinking again

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: btree shrinking again
Date: 2002-11-17 16:31:31
Message-ID: 20021117163131.GC4063@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I'm just taking the btree shrinking problem, and saw in the README:

+ Deletions are handled by getting a super-exclusive lock on the target
page, so that no other backend has a pin on the page when the deletion
starts. This means no scan is pointing at the page. This is OK for
deleting leaf items, probably not OK for deleting internal nodes;
will need to think harder when it's time to support index compaction.

In what cases is not OK to delete an item from an internal node, holding
a super-exclusive lock? (I assume this means LockBufferForCleanup()).

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Los dioses no protegen a los insensatos. Éstos reciben protección de
otros insensatos mejor dotados" (Luis Wu, Mundo Anillo)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Patrick Welche 2002-11-17 16:57:21 Re: Debian build prob
Previous Message Alvaro Herrera 2002-11-17 14:07:41 pg_stat_database shows userid as OID