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