Skip site navigation (1) Skip section navigation (2)

Re: Understanding the output of EXPLAIN ANALYSE

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: "Thurber, Fred" <Fred(dot)Thurber(at)gdit(dot)com>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Understanding the output of EXPLAIN ANALYSE
Date: 2009-07-28 09:50:58
Message-ID: 4A6ECA02.5080909@netzmeister-st-pauli.de (view raw or flat)
Thread:
Lists: pgsql-novice
Thurber, Fred schrieb:
> 
> Now we added a couple of indexes, and it seemingly slowed down, but the estimated cost was lower:

which indexes did you add? As far as I can see, there is only bobs_grid_index used in both 
plans. And just to mention it - did you run VACUUM and / or ANAYLZE?

Cheers

Andy

In response to

pgsql-novice by date

Next:From: Andreas WenkDate: 2009-07-28 09:56:42
Subject: Re: Location of databases
Previous:From: Michael WoodDate: 2009-07-28 09:48:45
Subject: Re: Location of databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group