[postgis-devel] [PostGIS] #1447: geometry op class for index only scans (PostgreSQL 9.2+)

[PostGIS]

#1447: geometry op class for index only scans (PostgreSQL 9.2+)
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------
 PostgreSQL 9.2 now supports index only scans.  Originally I thought we
 couldn't take advantage of it, but I suspect it might help with quick &&
 count checks.

 See this thread.

 http://archives.postgresql.org/pgsql-hackers/2012-01/msg00414.php
 sadly this won't help much with the more useful use case of

 ST_Intersects(... ) as that still needs to pull the geometry though I
 guess it would only need in the case of if index check passes so might
 still be very useful.  Dunno.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1447>
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.