[postgis-users] Looking for more performance on select

Mark Cave-Ayland mark.cave-ayland at ilande.co.uk
Wed Dec 27 15:14:09 PST 2006


On Tue, 2006-12-26 at 15:33 -0500, Obe, Regina wrote:
> I just noticed something else in your explain.  Its doing a seq scan
> on your streets_db_edges.  I would have expected that to be an index
> scan.
>  
> Are the data types of your id and edge_id of the same type? If they
> aren't then it would do a seq scan instead of indexed scan.  I know at
> least in earlier versions  if you had an int8 in one table and an int4
> in another, it would not do an index scan.  This might have changed in
> the 8.2 version.


Actually, it changed in the 8.0 version :D


Kind regards,

Mark.






More information about the postgis-users mailing list