increasing query time after analyze

From: Katharina Koobs
Subject: increasing query time after analyze
Date: ,
Msg-id: 000f01cf2268$8537e610$8fa7b230$@uni-konstanz.de
(view: Whole thread, Raw)
Responses: Re: increasing query time after analyze  (Pavel Stehule)
Re: increasing query time after analyze  (Claudio Freire)
List: pgsql-performance

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?

 

Thanks a lot for your help!

 

Katharina

 

 


pgsql-performance by date:

From: bricklen
Date:
Subject: Re: Postgres Query Plan Live Lock
From: "Pweaver (Paul Weaver)"
Date:
Subject: Re: Postgres Query Plan Live Lock