Re: Manual vs automatic functionality

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql(at)mohawksoft(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Manual vs automatic functionality
Date: 2005-03-05 17:05:27
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sat, Mar 05, 2005 at 11:05:32AM -0500, pgsql(at)mohawksoft(dot)com wrote:

> Being able to assign "hints" to queries may be able to allow DBAs to tune
> queries in tables who's characteristics are misrepresented by the
> statistics in ANALYZE.

I wouldn't mind being able to provide hints to the planner. For
example, I have some set-returning functions that typically return
10-100 rows and I usually have a good idea of how many rows a
particular set of inputs will generate, and sometimes I know other
characteristics about those rows as well. But the planner, not
knowing any better, always assumes the functions will return 1000
rows, which presumably affects the plan, sometimes for the worse.
Here's an example of a problem I've had:

I've wondered if the ability to provide hints about the expected
output from set-returning functions would be useful.

Michael Fuhr

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alex 2005-03-05 17:56:16 Explicit Transaction Priority
Previous Message pgsql 2005-03-05 16:05:32 Manual vs automatic functionality