From: Katharina Koobs <katharina.koobs@uni-konstanz.de>
To: pgsql-performance@postgresql.org
Subject: increasing query time after analyze
Date: Wed, 12 Feb 2014 09:58:49 +0100
Message-ID: <005e01cf27d0$a52ec3e0$ef8c4ba0$@uni-konstanz.de> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi,
We have still problems with our query time.
After restoring the database the query time is about one minute.
After an analyze the query time is about 70 minutes.
We could discover one table which cause the problem.
After analyzing this table the query time increases.
We have made an explain plan before and after analyzing the table cifx.
The plans can be found on
After analyze:
explain.depesz.com/s/HuZ
Before analyze:
explain.depesz.com/s/XWF
Thanks a lot for your help!
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: <005e01cf27d0$a52ec3e0$ef8c4ba0$@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