On Wed, Feb 5, 2014 at 8:50 AM, Katharina Koobs <[email protected]> wrote: > Hi, > > > > We have a PostgreSQL DB, version 9.3 on a Suse Linux system. > > We ran the update from postgresql 8.4 to 9.3. > > After importing the database the query time of one sql query is about 30 > sec. > > After ANALYZE the DB the query time of this sql query is about 45 minutes. > > We can see that after analyzing the indexes will no longer be used. > > > > Has anyone an idea why ANALYZE cause this problem?
If you just restored a dump, you should do a VACUUM ANALYZE. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
