Обсуждение: Information schema tweak?

Поиск
Список
Период
Сортировка

Information schema tweak?

От
Christopher Kings-Lynne
Дата:
The current _pg_keypositions function generates the numbers from 1 to 32 
using a massive union, shouldn't it just use generate_series instead (to 
make it faster/simpler)?

Chris


Re: Information schema tweak?

От
Tom Lane
Дата:
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> The current _pg_keypositions function generates the numbers from 1 to 32 
> using a massive union,

Only for very small values of "current" ...
        regards, tom lane


Re: Information schema tweak?

От
Christopher Kings-Lynne
Дата:
> Only for very small values of "current" ...

Argh! Forgot it was a 7.4 server :)  Oops.