<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16446"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial>Alex,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 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 class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/">http://trac.osgeo.org/postgis/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial>Slate it for 2.1.0</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=375355213-01072012><FONT color=#0000ff
size=2 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 class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <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>
<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></BLOCKQUOTE></BODY></HTML>