Re: So, is COUNT(*) fast now?
| От | Jeff Janes |
|---|---|
| Тема | Re: So, is COUNT(*) fast now? |
| Дата | |
| Msg-id | CAMkU=1wp3FskYnCjks4Sj-WZ6wBqHaSTr-0EF6-EDF1LyTDQ-w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: So, is COUNT(*) fast now? (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: So, is COUNT(*) fast now?
|
| Список | pgsql-hackers |
On Fri, Oct 21, 2011 at 12:52 PM, Robert Haas <robertmhaas@gmail.com> wrote: > > Also, this line is kind of expensive: > > if (!visibilitymap_test(scandesc->heapRelation, > ItemPointerGetBlockNumber(tid), > &node->ioss_VMBuffer)) > > Around 2%. But I don't see any way to avoid that, or even make it cheaper. Could we cache by ItemPointerGetBlockNumber(tid) the results of those tests, for groups of tids on the same index page? How useful this would be would depend on how well-clustered the table and index are. Cheers, Jeff
В списке pgsql-hackers по дате отправления: