[postgis-users] Indexes (ENABLE_SEQSCAN)

[Alexandre Florio]

Hi,

    Analyzing the archives, this seems to be an exhaustively discussed problem which was apparently fixed in version 0.6.

    The documentation says that I do not need, anymore, to use "SET ENABLE_SEQSCAN=OFF" to force the planner to use the spatial index.  Nevertheless, I have a database in which a query do execute much faster when setting ENABLE_SEQSCAN to OFF.

    Before dumping the table scheme, queries and outputs I would like to confirm that this should not happen in the current version of PostGIS (0.8.2).

Thanks,
Alexandre Florio

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040826/23d59f7c/attachment.pgp>