| From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: optimizer hints? |
| Date: | 2001-06-06 00:23:49 |
| Message-ID: | Pine.BSO.4.10.10106052023250.17529-100000@spider.pilosoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 5 Jun 2001, Tom Lane wrote:
> Alex Pilosov <alex(at)pilosoft(dot)com> writes:
> > Example: Index scan when data in index is stored in approximately same
> > order in physical table will be fast. Index scan when index order does not
> > match table order will be slow. I don't see a way you can explain _that_
> > to optimizer, nor I really want to.
>
> Precisely why you should leave it to the optimizer to figure
> these things out for itself. Curiously enough, there is a
> physical-order-correlation statistic in pg_statistic now ;-)
You keep impressing me, Tom. I bow before your superior wisdom :)
-alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tauren Mills | 2001-06-06 00:59:28 | Specifying psql password on command line |
| Previous Message | Andrew Snow | 2001-06-06 00:17:18 | RE: XML question |