Re: tidscan not work ? Pg 8.4.5 + WinXP

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: tidscan not work ? Pg 8.4.5 + WinXP
Date: 2010-12-01 11:38:21
Message-ID: AANLkTink5Z4AGWTmZiSUwaay6fOEY0kAX4ijkxnc8kzH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2010-12-01 13:48:01 Re: BBU Cache vs. spindles
Previous Message Pierre C 2010-12-01 08:43:07 Re: SELECT INTO large FKyed table is slow