Re: [HACKERS] Manual vs automatic functionality

2005-03-05 Thread Christopher Kings-Lynne
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 we

Re: [HACKERS] Manual vs automatic functionality

2005-03-05 Thread Michael Fuhr
On Sat, Mar 05, 2005 at 11:05:32AM -0500, [EMAIL PROTECTED] 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.

[HACKERS] Manual vs automatic functionality

2005-03-05 Thread pgsql
Tom recently said, when talking about allowing the user (in this case me) from passing a hash table size to "create index:" "but that doesn't mean I want to make the user deal with it." I started thinking about this and, maybe I'm old fashioned, but I would like the ability to deal with it. So m