Re: multi-column btree index for real values - Mailing list pgsql-general

From Bruce Momjian
Subject Re: multi-column btree index for real values
Date
Msg-id 200210052139.g95Ldjv02630@candle.pha.pa.us
Whole thread Raw
In response to Re: multi-column btree index for real values  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
Responses Re: multi-column btree index for real values  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
List pgsql-general
Martin Weinberg wrote:
> Thanks Bruce.  Some simple tests on a 10 million tuple data base shows
> that r-tree works well for this. (It took me a while to realize
> that I had to sort boxes of zero area rather than points).
>
> However, it seems that the rtree index has a serious memory leak for
> 7.2.2.  Is that known?

Uh, I am not aware of that, but you can try 7.3beta to see if it is
better, and if not, report back.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Martin Weinberg
Date:
Subject: Re: multi-column btree index for real values
Next
From: Martin Weinberg
Date:
Subject: Re: multi-column btree index for real values