Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WB10M-0000s5-9X for pgsql-performance@arkaria.postgresql.org; Wed, 05 Feb 2014 11:50:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WB10L-0003PJ-C1 for pgsql-performance@arkaria.postgresql.org; Wed, 05 Feb 2014 11:50:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WB10J-0003PC-U8 for pgsql-performance@postgresql.org; Wed, 05 Feb 2014 11:50:56 +0000 Received: from pyrimidin.rz.uni-konstanz.de ([134.34.240.46]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WB10C-0007ax-Ti for pgsql-performance@postgresql.org; Wed, 05 Feb 2014 11:50:55 +0000 Received: from vw002335.verwaltung.uni-konstanz.de (HELO PCKKoobs) ([134.34.168.164]) by mailhub.uni-konstanz.de with ESMTP/TLS/AES128-SHA; 05 Feb 2014 11:50:47 +0000 From: "Katharina Koobs" To: Subject: increasing query time after analyze Date: Wed, 5 Feb 2014 12:50:52 +0100 Message-ID: <000f01cf2268$8537e610$8fa7b230$@uni-konstanz.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01CF2270.E6FF5B50" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac8iZzzzpirLyViaROyFd2RqmUAmMw== Content-Language: de X-Pg-Spam-Score: -2.8 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_0010_01CF2270.E6FF5B50 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0010_01CF2270.E6FF5B50 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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

 

 

------=_NextPart_000_0010_01CF2270.E6FF5B50--