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 по дате отправления