On 20/10/11 16:31, Frederic Junod wrote:
The database was imported with postgis_restore.pl. I've also tried to
reindex the database.
Note that on both instances, if the st_buffer is removed the indexes are used.
What's happening ?
Hi Frederic,
You'll have to post the EXPLAIN ANALYZE output
your old should be using
> costing metrics as well so not sure why it would switch between now.
>
> Hope that helps,
> Regina
> http://www.postgis.us
>
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net
> [mailto:postgis-users-boun...@postgis.r
postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Frederic
Junod
Sent: Thursday, October 20, 2011 11:32 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Indexes used in 1.3.3 but not in 1.5.3
Hello,
With postgis 1.3.3 on postgresql 8.3.14, the following
Hello,
With postgis 1.3.3 on postgresql 8.3.14, the following select uses the indexes:
EXPLAIN SELECT 1 FROM grid_pk25, grid_geocover WHERE
st_overlaps(st_buffer(grid_geocover.the_geom, -1),
grid_pk25.the_geom);
QUERY PLAN
-