Re: sql row constructor...works!

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: sql row constructor...works!
Дата
Msg-id 43E8DA05.3000104@agliodbs.com
обсуждение исходный текст
Ответ на sql row constructor...works!  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: sql row constructor...works!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Merlin,

> Thanks for bringing the SQL 92 row constructor into spec for
> operations involving > and <.  This is just fantastic. I just
> benchmarked ISAM style access to tables on multi-part keys and the
> speedup is tremendous vs. the non row-constructor approach to the
> problem which is tedius to write and only selective to the first part
> of the key.  We are talking speedups proportional to the inselectivity
> of the ordering key.  While this feature is relatively esoteric, it is
> powerful and belongs in every dba's bag of tricks.

It's esoteric enough that I don't know what you're talking about.  Can 
you give us an example?

--Josh


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: sql row constructor...works!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PORTS] Failed install - libgen.so doesn't exist