Re: Adding support for Row Compares to nbtree startikey optimization
От | Chao Li |
---|---|
Тема | Re: Adding support for Row Compares to nbtree startikey optimization |
Дата | |
Msg-id | 175523985114.994.399192844268418577.pgcf@coridan.postgresql.org обсуждение исходный текст |
Ответы |
Re: Adding support for Row Compares to nbtree startikey optimization
Re: Adding support for Row Compares to nbtree startikey optimization |
Список | pgsql-hackers |
I tested the patch. Basically all of my test cases passed. Just a few small comments: + if (subkey->sk_attno > firstchangingattnum) /* >, not >= */ + break; Can we enhance the comment to something like ">, not >= because firstchangingattnum starting from 1". + /* + * Compare the last tuple's datum for this row compare member + * (unless we already know that lasttup must satisfy qual) + */ + if (!lastsatisfied) + { When subkey->sk_attno <= firstchangingattnum, if first is not satisfied, then last should not be satisfied either, so wecan skip check last. The new status of this patch is: Waiting on Author
В списке pgsql-hackers по дате отправления: