On Wed, Feb 5, 2014 at 8:50 AM, Katharina Koobs
<katharina.koobs@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.