Re: [GENERAL] Keyed Tables

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 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.

Yes, it is a nice feature, but we don't support it.  We do have CLUSTER,
but that is not as nice.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026