On Wed, Mar 23, 2011 at 6:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Claudio Freire <klaussfreire(at)gmail(dot)com> writes:
>> In my head, safer = better worst-case performance.
>
> If the planner starts operating on the basis of worst case rather than
> expected-case performance, the complaints will be far more numerous than
> they are today.

I imagine, that's why, if you put my comment in context, I was talking
about picking a safer plan only when the "better on average one" fails
miserably.

In response to

• Re: Shouldn't we have a way to avoid "risky" plans? at 2011-03-23 21:00:04 from Tom Lane

Responses

• Re: Shouldn't we have a way to avoid "risky" plans? at 2011-03-25 17:55:08 from Scott Carey

pgsql-performance by date

Next:	From: Marti Raudsepp	Date: 2011-03-23 21:56:16
	Subject: Re: Slow query on CLUTER -ed tables
Previous:	From: Tom Lane	Date: 2011-03-23 21:00:04
	Subject: Re: Shouldn't we have a way to avoid "risky" plans?