<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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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>