On Wed, Feb 5, 2014 at 8:50 AM, Katharina Koobs <katharina.ko...@uni-konstanz.de> 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
