<div>Done: <a href="http://trac.osgeo.org/postgis/ticket/1895">http://trac.osgeo.org/postgis/ticket/1895</a></div><br clear="all">------<br>With best regards,<br>Alexander Korotkov.<div><br><div class="gmail_quote">On Sun, Jul 1, 2012 at 5:54 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Alex,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Can you attach this to a ticket. That way Paul won't
forget or one of us can remind him when he does :)</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://trac.osgeo.org/postgis/" target="_blank">http://trac.osgeo.org/postgis/</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Slate it for 2.1.0</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div><br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px" dir="ltr">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><b>From:</b>
<a href="mailto:postgis-devel-bounces@postgis.refractions.net" target="_blank">postgis-devel-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-devel-bounces@postgis.refractions.net" target="_blank">postgis-devel-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Alexander Korotkov<br><b>Sent:</b> Sunday, July 01, 2012 8:33
AM<br><b>To:</b> PostGIS Development Discussion<br><b>Subject:</b> Re:
[postgis-devel] New node splitting algorithm for GiST<br></font><br></div><div><div class="h5">
<div></div>
<div class="gmail_quote">On Sat, Jun 30, 2012 at 10:59 PM, Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@opengeo.org" target="_blank">pramsey@opengeo.org</a>></span> wrote:
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">No progress, still an "item of interest" in my list of
things I might<br>do. If you prepare a compile-time conditional patch, I'd
be interested<br>in reviewing and applying it.<br></blockquote>
<div><br></div>
<div>OK, it's here.</div>
<div>Just an small example. Without patch.</div>
<div><br></div>
<div>
<div><font face="'courier new', monospace">test=# create index geonames_idx on
geonames using gist (point);</font></div>
<div><font face="'courier new', monospace">CREATE INDEX</font></div>
<div><font face="'courier new', monospace">Time: 113796,848 ms</font></div>
<div><font face="'courier new', monospace"><br></font></div>
<div><font face="'courier new', monospace">test=# explain (analyze, buffers)
select * from geonames where point && 'BOX(34.4671 126.631,34.5023
126.667)'::box2d::geometry;</font></div>
<div><font face="'courier new', monospace">
QUERY PLAN
</font></div>
<div><font face="'courier new', monospace">---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font></div>
<div><font face="'courier new', monospace"> Index Scan using geonames_idx
on geonames (cost=0.00..14.05 rows=2 width=128) (actual
time=0.589..0.876 rows=11 loops=1)</font></div>
<div><font face="'courier new', monospace"> Index Cond: (point
&&
'0103000000010000000500000016FBCBEEC93B4140AAF1D24D62A85F4016FBCBEEC93B4140A69BC420B0AA5F40F163CC5D4B404140A69BC420B0AA5F40F163CC5D4B404140AAF1D24D62A85F4016FBCBEEC93B4140AAF1D24D62A85F40'::geometry)</font></div>
<div><font face="'courier new', monospace"> Buffers: shared
hit=26</font></div>
<div><font face="'courier new', monospace"> Total runtime: 0.927
ms</font></div>
<div><font face="'courier new', monospace">(4 rows)</font></div>
<div><font face="'courier new', monospace"><br></font></div>
<div><font face="arial, helvetica, sans-serif">With patch.</font></div>
<div><font face="'courier new', monospace"><br></font></div>
<div><font face="'courier new', monospace">test=# create index geonames2_idx
on geonames2 using gist (point);</font></div>
<div><font face="'courier new', monospace">CREATE INDEX</font></div>
<div><font face="'courier new', monospace">Time: 118382,076 ms</font></div>
<div><font face="'courier new', monospace"><br></font></div>
<div><font face="'courier new', monospace">test=# explain (analyze, buffers)
select * from geonames2 where point && 'BOX(34.4671 126.631,34.5023
126.667)'::box2d::geometry;</font></div>
<div><font face="'courier new', monospace"><br></font></div>
<div><font face="'courier new', monospace">
QUERY PLAN
</font></div>
<div><font face="'courier new', monospace">---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font></div>
<div><font face="'courier new', monospace"> Index Scan using
geonames2_idx on geonames2 (cost=0.00..22.40 rows=4 width=128) (actual
time=0.209..0.225 rows=11 loops=1)</font></div>
<div><font face="'courier new', monospace"> Index Cond: (point
&&
'0103000000010000000500000016FBCBEEC93B4140AAF1D24D62A85F4016FBCBEEC93B4140A69BC420B0AA5F40F163CC5D4B404140A69BC420B0AA5F40F163CC5D4B404140AAF1D24D62A85F4016FBCBEEC93B4140AAF1D24D62A85F40'::geometry)</font></div>
<div><font face="'courier new', monospace"> Buffers: shared
hit=11</font></div>
<div><font face="'courier new', monospace"> Total runtime: 0.276
ms</font></div>
<div><font face="'courier new', monospace">(4 rows)</font></div></div>
<div><br></div>
<div>------</div>With best regards,<br>Alexander Korotkov.
</div></div></div></blockquote></div>
<br>_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-devel" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a><br>
<br></blockquote></div><br></div>