Spatial Joins

[Eric Shuman]

Hi list,

What options are there for spatially joining the centroid of one polygon
layer to another polygon layer?

I have been trying to preprocess some data by running a join using postGIS,
but after 2+ hours I give up on it.  A similar join using the same data in
ArcView only takes 3 minutes.

My PostGIS layers have spatial indexes and running an EXPLAIN on the query
shows that the indexes are being used.

Any help figuring out how to optimize spatial joins (Or some links to get me
on the right track) would be greatly appreciated!

~Eric