Re: making update/delete of inheritance trees scale better

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: making update/delete of inheritance trees scale better
Дата
Msg-id 137701.1612562024@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: making update/delete of inheritance trees scale better  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> As to why it causes us pain, I don't have a full picture of that.
> Target list construction is one problem: we build all these target
> lists for intermediate notes during planning and they're long enough
> -- if the user has a bunch of columns -- and planning is cheap enough
> for some queries that the sheer time to construct the list shows up
> noticeably in profiles.

Well, the tlist data structure is just about completely separate from
the TupleTableSlot mechanisms.  I'm more prepared to believe that
we could improve on the former, though I don't have any immediate
ideas about how.

            regards, tom lane



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: automatic analyze: readahead - add "IO read time" log message
Следующее
От: Jacob Champion
Дата:
Сообщение: Re: More test/kerberos tweaks