Re: tidscan not work ? Pg 8.4.5 + WinXP

Поиск
Список
Период
Сортировка
От pasman pasmański
Тема Re: tidscan not work ? Pg 8.4.5 + WinXP
Дата
Msg-id AANLkTink5Z4AGWTmZiSUwaay6fOEY0kAX4ijkxnc8kzH@mail.gmail.com
обсуждение исходный текст
Ответ на tidscan not work ? Pg 8.4.5 + WinXP  (pasman pasmański <pasman.p@gmail.com>)
Список pgsql-performance
>FWIW, it isn't going to happen anyway, because the TID scan mechanism
>doesn't support scanning based on a join condition.  That hasn't gotten
>to the top of the to-do list because the use case is almost vanishingly
>small.  ctids generally aren't stable enough for it to be useful to
>store references to one table's ctids in another table.

Thanks for explanation.


--
------------
pasman

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

Предыдущее
От: "Pierre C"
Дата:
Сообщение: Re: SELECT INTO large FKyed table is slow
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BBU Cache vs. spindles