| From: | Thomas Lockhart <thomas(at)fourpalms(dot)org> |
|---|---|
| To: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
| Cc: | mlw <markw(at)mohawksoft(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Louis-David Mitterrand <vindex(at)apartia(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Index Scans become Seq Scans after VACUUM ANALYSE |
| Date: | 2002-04-17 15:01:06 |
| Message-ID: | 3CBD8E32.B9F6616A@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
...
> Weighing these factors, perhaps once we get one or two complaining about
> postgresql using an index vs 20 complaining about not using an index, then
> the optimizer values have reached a good compromise :). But maybe the ratio
> should be 1 vs 100?
:)
So we should work on collecting those statistics, rather than statistics
on data. What do you think Tom; should we work on a "mailing list based
planner" which adjusts numbers from, say, a web site? That is just too
funny :)))
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2002-04-17 15:09:27 | Re: Implicit coercions need to be reined in |
| Previous Message | Lincoln Yeoh | 2002-04-17 14:59:48 | Re: Index Scans become Seq Scans after VACUUM ANALYSE |