Remember to set up your geographic indexes in postgis

They will create R-Trees for searching the geometric columns in such a way that geometric queries will be boosted in speed.

CREATE INDEX useful_index ON mytable USING GIST ( the_geometric_column_in_mytable );
VACUUM ANALYZE mytable;