[postgis-devel] [PostGIS] #1828: Estimate returned by geography_gist_selectivity results in slow query plan for ST_DWithin

[Sandro Santilli]

On Thu, Jun 21, 2012 at 08:09:30PM -0000, PostGIS wrote:
> #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.2
> Component:  postgis        |     Version:  2.0.x        
>  Keywords:                 |  
> ---------------------------+------------------------------------------------
> 
> Comment(by mcayland):
> 
>  One of the delays on this is that my dev environment is set up for 9.0 and
>  so WITH... INSERT doesn't work. I've used the following as a substitute:

FYI, all you need is to put the INSERT first:

  INSERT INTO xxx WITH ... 

--strk(on 8.4);