From: | "Mark Woodward" <pgsql(at)mohawksoft(dot)com> |
---|---|
To: | "Gregory Stark" <stark(at)enterprisedb(dot)com> |
Cc: | "Jaime Casanova" <systemguards(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Index Tuning Features |
Date: | 2006-10-11 18:59:04 |
Message-ID: | 18272.24.91.171.78.1160593144.squirrel@mail.mohawksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> "Mark Woodward" <pgsql(at)mohawksoft(dot)com> writes:
>
>> The analyzer, at least the last time I checked, does not recognize these
>> relationships.
>
> The analyzer is imperfect but arguing from any particular imperfection is
> weak
> because someone will just come back and say we should work on that problem
> --
> though I note nobody's actually volunteering to do so whereas they appear
> to
> be for hints.
>
> I think the stronger argument is to say that there are some statistical
> properties that the analyzer _cannot_ be expected to figure out. Either
> because
>
> a) they're simply too complex to ever expect to be able to find
> automatically,
>
> b) too expensive to make it worthwhile in the general case, or
>
> c) because of some operational issue such as the data changing frequently
> enough that the analyzes that would be necessary to keep the statistics
> up
> to date would become excessively expensive or even be impossible to
> perform rapidly enough.
Well, from a purely data domain standpoint, it is impossible to charactize
the exact nature of a data set without enough information to recreate it.
Anything less must be designed for a fixed set of assumptions. There is no
way that every specific trend can be covered by a fixed number of
assumptions.
The argument that all we need is better statistics completely misses the
point. There will *always* be a number cases where the planner will not
work optimally. I would say that a "simpler" planner with better hints
will always be capable of creating a better query plan.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-10-11 19:10:23 | Re: Index Tuning Features |
Previous Message | Tom Lane | 2006-10-11 18:34:45 | Re: Modification to the postgres catalog |