Re: Why isn't PG using an index-only scan?

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Why isn't PG using an index-only scan?
Дата
Msg-id CAApHDvrQxSO8SJGHqiRuhuSacy5idavz4EkKKfW76qaELHKSOg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why isn't PG using an index-only scan?  (Jean-Christophe BOGGIO <postgresql@thefreecat.org>)
Список pgsql-performance
On Thu, 18 Sept 2025 at 19:45, Jean-Christophe BOGGIO
<postgresql@thefreecat.org> wrote:
> Ok but then why is it doing it on the AD table? Is it because of the
> number of rows?

It's hard to tell as I don't have a clear view on which columns are
from which tables.  Perhaps "ad" can Index Only Scan because all of
the columns required are in an index but with "oeu" there's a column
being used that's not indexed?

David



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