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