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
обсуждение исходный текст
Ответ на 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 .  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thu, Sep 24, 2009 at 8:25 PM, Josh Berkus <josh@agliodbs.com> 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
Дата:
Сообщение: Re: Many left outer joins with limit performance
Следующее
От: Robert Haas
Дата:
Сообщение: Re: query memory consumption