Re: make add_paths_to_append_rel aware of startup cost - Mailing list pgsql-hackers

From Andy Fan
Subject Re: make add_paths_to_append_rel aware of startup cost
Date
Msg-id 87sf1tgq3c.fsf@163.com
Whole thread Raw
In response to Re: make add_paths_to_append_rel aware of startup cost  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
David Rowley <dgrowleyml@gmail.com> writes:

> I'd be more happy using this one as percentage-wise, the cost
> difference is much larger.

+1 for the percentage-wise.
>
> I checked that the t2.thounsand = 0 query still tests the cheap
> startup paths in add_paths_to_append_rel().

I get the same conclusion here. 
>
> So, if nobody has any better ideas, I'm just going to push the " and
> t2.thousand = 0" adjustment.

LGTM.

-- 
Best Regards
Andy Fan




pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: When extended query protocol ends?
Next
From: shihao zhong
Date:
Subject: Re: Fix incorrect PG_GETARG in pgcrypto