Jessica Richard <rjessil@yahoo.com> writes:
> After the entire upgrades, a same query with geospatial functions that used to come back in a few minutes, now take
about3 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