Re: index not used afer VACUUM ANALYZE

Hi,
I should state that I use 7.4beta1 under FreeBSD -current.

On Thu, 21 Aug 2003, mike wrote:

> Date: Thu, 21 Aug 2003 18:28:53 +0200 (CEST)
> From: mike <mike(at)reifenberger(dot)com>
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: index not used afer VACUUM ANALYZE
>
> Hi,
> I hav a db as specified in nit.sql
> flows has 763488 entries.
>
> After dropping/creating/loading the db and running auswert.sh I get
> the attached result from query1.txt.
> After 'VACUUM ANALYZE' I get the results from query2.txt
>
> As you can see, the indexes are not used any longer.
> Why?
>
> Bye/2
> ---
> Michael Reifenberger, Business Unit Manager SAP-Basis, Plaut Consulting
> Comp: Michael(dot)Reifenberger(at)plaut(dot)de | Priv: Michael(at)Reifenberger(dot)com
> http://www.plaut.de | http://www.Reifenberger.com
>

Bye/2
---
Michael Reifenberger, Business Unit Manager SAP-Basis, Plaut Consulting
Comp: Michael(dot)Reifenberger(at)plaut(dot)de | Priv: Michael(at)Reifenberger(dot)com
http://www.plaut.de | http://www.Reifenberger.com