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@reifenberger.com>
> To: pgsql-bugs@postgresql.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.Reifenberger@plaut.de | Priv: Michael@Reifenberger.com
>       http://www.plaut.de           |       http://www.Reifenberger.com
>

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