Postgres Pro
Downloads
Home   >   mailing lists

increasing query time after analyze - Mailing list pgsql-performance

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

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:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Postgres Query Plan Live Lock
Next
From: Pavel Stehule
Date:
Subject: Re: increasing query time after analyze