Re[2]: [HACKERS] Fwd: Joins and links

Поиск
Список
Период
Сортировка
От Leon
Тема Re[2]: [HACKERS] Fwd: Joins and links
Дата
Msg-id 1332.990706@udmnet.ru
обсуждение исходный текст
Ответ на Re: [HACKERS] Fwd: Joins and links  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Hello Bruce,

Tuesday, July 06, 1999 you wrote:

B> Actually, there is:

B>         select ctid from pg_class;

B>         ctid
B>         ------
B>         (0,1)
B>         (0,2)
B>         ...

B> The number is the block number offset in the block.  It doesn't help
B> because UPDATED rows would get a new tid.  Tid's can be used for short
B> periods if you are sure the data in the table doesn't change, and there
B> is a TODO item to allow ctid reference in the WHERE clause.

It seems that you are moving in a right direction. But these tids
seem to be of short-term use, anyway. Why not to upgrade to full-featured
links at once?

Best regards, Leon




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Leon
Дата:
Сообщение: Re[4]: [HACKERS] Fwd: Joins and links
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re[4]: [HACKERS] Fwd: Joins and links