[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    Re: [postgis-devel] [PostGIS] #1828: Estimate returned by geography_gist_selectivity results in slow
From:       "PostGIS" <trac () osgeo ! org>
Date:       2012-05-23 14:25:08
Message-ID: 064.f64ed6a0b6145a1d6d53057827581168 () osgeo ! org
[Download RAW message or body]

#1828: Estimate returned by geography_gist_selectivity results in slow query plan
for ST_DWithin
---------------------------+------------------------------------------------
 Reporter:  realityexists  |       Owner:  mcayland     
     Type:  defect         |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 2.0.1
Component:  postgis        |     Version:  2.0.x        
 Keywords:                 |  
---------------------------+------------------------------------------------

Comment(by realityexists):

 The geometry one seems to have the same problem:
 {{{
 Seq Scan on _test_pos_geom  (cost=0.00..5517.00 rows=1 width=4) (actual
 time=3.342..14.989 rows=1415 loops=1)
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1828#comment:14>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer \
wiki, and a view into the subversion code repository of PostGIS project. \
_______________________________________________ postgis-devel mailing list
postgis-devel@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel


[prev in list] [next in list] [prev in thread] [next in thread]