Re: Regarding Sequential Scans count increase each time we press refresh .

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Regarding Sequential Scans count increase each time we press refresh .
Дата
Msg-id
603c8f070909271138p75905dfat68c1d6f4852a2284@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Regarding Sequential Scans count increase each time we press refresh . keshav upadhyaya <ukeshav2009@gmail.com>
Re: Regarding Sequential Scans count increase each time we press refresh . Josh Berkus <josh@agliodbs.com>
Re: Regarding Sequential Scans count increase each time we press refresh . Robert Haas <robertmhaas@gmail.com>
Re: Regarding Sequential Scans count increase each time we press refresh . Tom Lane <tgl@sss.pgh.pa.us>
On Thu, Sep 24, 2009 at 8:25 PM, Josh Berkus  wrote:
> You can't "turn off" sequential scans.  You can only make the planner
> less likely to choose them.  But if there's no way to get the data you
> need other than a seqscan, it's still going to do one.

And that's not a bad thing.  For a very small table, it's often the
fastest method.

...Robert
В списке pgsql-performance по дате отправления
От: Gerhard Wiesinger
Дата:
От: Robert Haas
Дата:
Сообщение: Re: query memory consumption
FAQ