From: Katharina Koobs <katharina.koobs@uni-konstanz.de>
To: pgsql-performance@postgresql.org
Subject: increasing query time after analyze
Date: Wed, 5 Feb 2014 12:50:52 +0100
Message-ID: <000f01cf2268$8537e610$8fa7b230$@uni-konstanz.de> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: katharina.koobs@uni-konstanz.de
Subject: Re: increasing query time after analyze
In-Reply-To: <000f01cf2268$8537e610$8fa7b230$@uni-konstanz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox