Keyed Tables
От | Glen and Rosanne Eustace |
---|---|
Тема | Keyed Tables |
Дата | |
Msg-id | 001201bea4d9$d035d540$0101a8c0@agree-1.godzone.net.nz обсуждение исходный текст |
Ответы |
Re: [GENERAL] Keyed Tables
|
Список | pgsql-general |
I thought I had already posted this query but now I can't remember. If I have please excuse the repeat. But as I can't remember the answer either can someone please comment. Is there likely to be any attempt to allow a table to be keyed. It seems that by default a table is created as a heap and in order to improve access speed, one must create indices on that table. I use Ingres at work and quite like the ability to do a 'modify table to btree' type of command. When the table concerned is basically only a key plus value, it seems rather inefficient to have to have both the heap and then an index when supposedly one could simply make the table into a btree in the first place. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen Eustace, on behalf of GodZone Internet Services, a division of AGRE Enterprises Limited. 176 Te Awe Awe St, Palmerston North, New Zealand Ph: +64 6 356 2562, Fax: +64 6 357 0271, Mobile: 025 416 184, http://WWW.GodZone.Net.NZ
В списке pgsql-general по дате отправления: