[BUGS] BUG #14525: select .* takes extremely long time

Поиск
Список
Период
Сортировка
От martin.langwisch@gmx.net
Тема [BUGS] BUG #14525: select .* takes extremely long time
Дата
Msg-id 20170202090519.1411.68788@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14525: select .* takes extremely long time  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14525
Logged by:          Martin Langwisch
Email address:      martin.langwisch@gmx.net
PostgreSQL version: 9.6.1
Operating system:   openSUSE 11.4 (x86_64)
Description:

I have a function f that returns a composite type.
The following query:
select f().*
takes about ten times as long as either
select f()
or
select (f).* from (select f() as f) a;

It doesn't matter whether the function returns a composite type or a set of
composite type.

This behaviour strikes me as odd, to say the least and it took me quite some
time to find out why my code was so slow.

yours
Martin


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?
Следующее
От: "Bogdan Bykhovets - ControlPay"
Дата:
Сообщение: [BUGS] Bug in postgres log file