Re: [postgis-users] query index trouble

2008-01-16 Thread Mark Cave-Ayland
On Wed, 2008-01-16 at 10:21 +1100, James M. Kelly wrote: Hi all I am fairly new to postGIS and postgreSQL, so I am still bumbling through a few performance issues at the moment. I am having some trouble with doing an inner join on a spatial table back with a normal table, and

[postgis-users] query index trouble

2008-01-15 Thread James M. Kelly
Hi all I am fairly new to postGIS and postgreSQL, so I am still bumbling through a few performance issues at the moment. I am having some trouble with doing an inner join on a spatial table back with a normal table, and from what I can see in the query analyser, it seems doesn't seem to be