| From: | mike <mike(at)Reifenberger(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | index not used afer VACUUM ANALYZE |
| Date: | 2003-08-21 16:28:53 |
| Message-ID: | 20030821172056.W1605-500000@mike.reifenberger.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| Attachment | Content-Type | Size |
|---|---|---|
| nit.sql | text/plain | 897 bytes |
| auswert.sh | text/plain | 3.8 KB |
| query1.txt | text/plain | 2.4 KB |
| query2.txt | text/plain | 2.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mike | 2003-08-21 16:30:06 | Re: index not used afer VACUUM ANALYZE |
| Previous Message | Tom Lane | 2003-08-21 14:49:10 | Re: 1.0 in function call not regarded as REAL in 7.3.2 |