Re: Unsplitting btree index leaf pages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unsplitting btree index leaf pages
Date: 2005-12-25 01:50:34
Message-ID: 22803.1135475434@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> BTW, if after having locked both pages we find that we have
> super-exclusive locks, i.e. nobody else has pins on these pages, we
> can reorganize much more agressively.

No, we cannot. I'm getting tired of explaining this.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-12-25 02:01:27 Re: Unsplitting btree index leaf pages
Previous Message Neil Conway 2005-12-25 01:41:15 pgsql: Minor doc tweak: "NOT NULL" is redundant with "SERIAL" in