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!
|
| Список | 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 по дате отправления: