On Tue, Jun 24, 2008 at 3:50 PM, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > On Tue, Jun 24, 2008 at 4:34 PM, Jeffrey Baker <[EMAIL PROTECTED]> wrote: >> Supposing the table is generally or strictly ordered by the column to be >> indexed, it would be more compact if the index stored ranges of tuples. >> Instead of storing the TID of every tuple with that value, the index would >> store a first and last TID, between which all tuples have the value. > > There are several databases which implement this idea. Unfortunately, > Postgres does not yet ensure that indexed tables remain indexed. >
Just for the records. you mean *ordered* tables, don't you? Postgres does not yet ensure that ordered tables remain ordered. -- regards, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
