From: | Glen and Rosanne Eustace <agree(at)godzone(dot)net(dot)nz> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Keyed Tables |
Date: | 1999-05-23 05:04:50 |
Message-ID: | 001201bea4d9$d035d540$0101a8c0@agree-1.godzone.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Hoffman | 1999-05-23 05:48:02 | Compile problem on BSDi 3.0 |
Previous Message | Gary Hoffman | 1999-05-23 04:49:21 |
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1999-05-23 05:51:50 | Re: [HACKERS] Current TODO list |
Previous Message | Bruce Momjian | 1999-05-23 01:12:19 | Re: [HACKERS] DEFAULT fixed |