Keyed Tables

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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