[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