Re: Some ExecSeqScan optimizations

Поиск
Список
Период
Сортировка
От Nikita Malakhov
Тема Re: Some ExecSeqScan optimizations
Дата
Msg-id CAN-LCVMMXqLj=j8Edqd99E9Pe1ayhWc8KyotfUfxv9-qV6ziqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Some ExecSeqScan optimizations  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Some ExecSeqScan optimizations
Список pgsql-hackers
Hi Amit!

It's a pity I missed this thread when you developed the patch.
I've developed a feature recently and discovered that SeqScan
does not make use of scan keys, and there is a Tom Lane's
comment regarding this:
  * Note that unlike IndexScan, SeqScan never use keys in heap_beginscan
  * (and this is very bad) - so, here we do not check are keys ok or not.

Have you considered passing scan keys like it is done in IndexScan?

Thanks!

--
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company

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