[postgis-users] Greetings, and road data questions

[Michael Graff]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andy Turk <andy at streetlight.com> writes:

> I misremembered things a little. The multikey index was indeed faster
> than a geometry index and a sequential scan. However, the "faster"
> version was still taking 10 seconds or so for a single query and I
> needed nearly instantaneous responses for an interactive application.

Has anyone tried clustering the table on the gist index?  In theory,
that would make it possible to group things that are close to one
another together, but I don't know exactly how that works with 2d (or
3d) data, where closeness ends up mapped into a 1d value.

- --Michael
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (NetBSD)
Comment: See http://www.flame.org/~explorer/pgp for my keys

iD8DBQE9sHYMl6Nz7kJWYWYRAou2AJ9d41xNKF4wvClAkG2Z6zc1XEZdDgCaAv67
HT3Fnz4vv98TEIZWK1jhFzM=
=PoH5
-----END PGP SIGNATURE-----