From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | David Warnock <david(at)sundayta(dot)co(dot)uk> |
Cc: | Leon <leon(at)udmnet(dot)ru>, pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Joins and links |
Date: | 1999-07-05 15:10:06 |
Message-ID: | 199907051510.LAA03606@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
> Leon,
>
> I have a few questions abo8ut what you are proposing.
>
> My background was in non SQL dbms (DataFlex) which supported recnums
> which as you pointed out had a number of advantages. However, recnums
> also have a significant number of problems. Some features like
> replication have significant dificulties. Others such as exporting and
> re-loading your data also need special work-arounds.
>
> A solution I have seen in some sql dbms (eg MS SQL Server) is to be able
> to choose one index and have the database table sorted by this index.
> Then you don't need a separate index for that sort-order. It means that
> almost any index can work like a recnum and avoid looking in both the
> index and the data. I am trying to remember the name of this feature but
> cannot at the moment.
>
We have CLUSTER command, but it is something that has to be run manually.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-07-05 15:16:02 | Re: [GENERAL] GROUP BY problem with 6.5 |
Previous Message | David Warnock | 1999-07-05 13:57:13 | Re: [GENERAL] Joins and links |
From | Date | Subject | |
---|---|---|---|
Next Message | Leon | 1999-07-05 15:24:52 | Fwd: Joins and links |
Previous Message | David Warnock | 1999-07-05 13:57:13 | Re: [GENERAL] Joins and links |