Jessica Richard <rjessil(at)yahoo(dot)com> writes:
> After the entire upgrades, a same query with geospatial functions that used to come back in a few minutes, now take about 3 minutes to finish, no erors, just much slower than before.
The standard first question is "did you remember to re-ANALYZE your
tables after reloading into the new database"?
regards, tom lane