[postgis-users] query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
mike at fuhr.org
Wed May 16 07:18:16 PDT 2007
On Wed, May 16, 2007 at 02:30:28PM +0200, TECHER David wrote:
> If you give us an example of SQL instructions you use perhaps someone
> could help you.
The EXPLAIN ANALYZE output of a slow query might also be helpful.
Also, did you ANALYZE all the tables after restoring them into
8.2.4? Are you running autovacuum or otherwise regularly vacuuming
and analyzing the tables? Do you have postgresql.conf settings
different in 8.2.4 than in the older version?
More information about the postgis-users