Keyed Tables

Glen and Rosanne Eustace <agree@godzone.net.nz>

From: Glen and Rosanne Eustace <agree@godzone.net.nz>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 1999-05-23T05:04:50Z
Lists: pgsql-hackers, 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