Why are there no inequality scans for ctid?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Why are there no inequality scans for ctid?
Дата
Msg-id 20130628083756.GA18266@depesz.com
обсуждение исходный текст
Ответы Re: Why are there no inequality scans for ctid?  (Atri Sharma <atri.jiit@gmail.com>)
Список pgsql-general
Hi,
while working on removing bloat from some table, I had to use ltos of
logic simply because there are no (idnexable) inequality scans for
ctids.

Is it because just noone thought about adding them, or are there some
more fundamental issues?

I could imagine that things like:

select * from table where ctid @ '123' could return all rows from 123rd
page, or I could:
select * from table where ctid >= '(123,0)' and ctid < '(124,0)';

Having such operators work would greatly improve bloat reducing
options.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/


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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: auto_explain & FDW
Следующее
От: Atri Sharma
Дата:
Сообщение: Re: Why are there no inequality scans for ctid?