Re: [PATCHES] rtree: improve performance, tuple killing

2005-01-18 Thread Neil Conway
On Tue, 2005-01-18 at 16:43 +1100, Neil Conway wrote: > Barring any objections, I intend to apply this patch tomorrow. Applied. -Neil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-no

Re: [PATCHES] rtree: improve performance, tuple killing

2005-01-17 Thread Neil Conway
Barring any objections, I intend to apply this patch tomorrow. The patch, as well as the original -patches email, are included below. -Neil On Wed, 2004-11-24 at 11:15 +1100, Neil Conway wrote: > This patch makes some improvements to the rtree index implementation: > > (1) Keep a pin on the scan

Re: [PATCHES] rtree: improve performance, tuple killing

2004-11-23 Thread Neil Conway
On Tue, 2004-11-23 at 23:40 -0500, Tom Lane wrote: > Please hold this for the 8.1 cycle. I think we are past the time for > non-bug-fix changes in the 8.0 release. Sorry, I should have mentioned that explicitly: I have (and had) no intention of applying this for 8.0. -Neil ---

Re: [PATCHES] rtree: improve performance, tuple killing

2004-11-23 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > This patch makes some improvements to the rtree index implementation: Please hold this for the 8.1 cycle. I think we are past the time for non-bug-fix changes in the 8.0 release. regards, tom lane ---(end

[PATCHES] rtree: improve performance, tuple killing

2004-11-23 Thread Neil Conway
This patch makes some improvements to the rtree index implementation: (1) Keep a pin on the scan's current buffer and mark buffer. This avoids the need to do a ReadBuffer() for each tuple produced by the scan. (2) Convert a ReleaseBuffer() ; ReadBuffer() pair into ReleaseAndReadBuffer(). Surely n