Re: Index Tuning Features

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.

In response to

Responses

Browse pgsql-hackers by date

  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