Re: Small improvement to tlist_matches_tupdesc()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Small improvement to tlist_matches_tupdesc()
Дата
Msg-id 11156.1446089269@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Small improvement to tlist_matches_tupdesc()  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
David Rowley <david.rowley@2ndquadrant.com> writes:
> I just found myself in execScan.c. I noticed that tlist_matches_tupdesc()
> is a bit wasteful in some cases as it goes to the trouble of matching the
> tlist to the TupleDesc item by item until it runs out of tlist items
> or finds a non-match. Once the loop completes it ensures that all tlist
> items were consumed, so basically in other words, it checks the lengths
> match.

> I think likely this was just not made optimal originally in d0b4399 when
> the length property etc were added to List

No, it's modeled after other places that allow for ignoring dropped
columns in one or both lists.  While this code doesn't currently allow
that, the patch you suggest would prevent it from ever doing so (at least
not without reverting the patch first).  I'd be okay with that if there
were evidence of a meaningful performance gain from it ... but you've
not provided any.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Small improvement to tlist_matches_tupdesc()
Следующее
От: Noah Misch
Дата:
Сообщение: Re: Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::')