patch: fix performance problems with repated decomprimation of varlena values in plpgsql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема patch: fix performance problems with repated decomprimation of varlena values in plpgsql
Дата
Msg-id AANLkTintO8HQST-D8_hE+pANpT+zqnavuHL2auFFD_OS@mail.gmail.com
обсуждение исходный текст
Ответы Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql  (Andrew Dunstan <andrew@dunslane.net>)
Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql  (Noah Misch <noah@leadboat.com>)
Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Hello

this patch remove a multiple detoasting of varlena values in plpgsql.

It is usable mainly for iteration over longer array directly loaded
from relation.

It's doesn't have a impact on semantic or behave - it's just eliminate
some performance trap.

sample: table 10000 rows one column with array with 1000 string fields:

patched pl time: 6 sec
unpatched pl time: 170 sec

This doesn't change my opinion on FOR-IN-ARRAY cycle (is still
important for readability) - just remove one critical performance
issue

Regards

Pavel Stehule

Вложения

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Explain analyze getrusage tracking
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: format() with embedded to_char() formatter