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)
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 |