[postgis-users] query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade

[Michael Fuhr]

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?

-- 
Michael Fuhr