Re: tidscan not work ? Pg 8.4.5 + WinXP - Mailing list pgsql-performance

From pasman pasmański
Subject Re: tidscan not work ? Pg 8.4.5 + WinXP
Date
Msg-id AANLkTink5Z4AGWTmZiSUwaay6fOEY0kAX4ijkxnc8kzH@mail.gmail.com
Whole thread Raw
In response to tidscan not work ? Pg 8.4.5 + WinXP  (pasman pasmański <pasman.p@gmail.com>)
List 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 by date:

Previous
From: "Pierre C"
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: Bruce Momjian
Date:
Subject: Re: BBU Cache vs. spindles