Postgres Pro
Downloads
Home   >   mailing lists

index not used afer VACUUM ANALYZE - Mailing list pgsql-bugs

From mike
Subject index not used afer VACUUM ANALYZE
Date
Msg-id 20030821172056.W1605-500000@mike.reifenberger.com
Whole thread Raw
Responses Re: index not used afer VACUUM ANALYZE
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: mike
Date:
Subject: Re: index not used afer VACUUM ANALYZE
Next
From: Ryan Mooney
Date:
Subject: Re: [INTERFACES] ECPG Connect user :variable problem