Re: scan_recycle_buffers

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: scan_recycle_buffers
Дата
Msg-id 1173485615.23455.7.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Re: scan_recycle_buffers  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-patches
On Fri, 2007-03-09 at 20:37 +0000, Simon Riggs wrote:
> > I wonder if calling RelationGetNumberOfBlocks on every seq scan becomes
> > a performance issue for tiny tables with for example just 1 page. It
> > performs an lseek, which isn't free.
>
> Jeff's patch does this also, for similar reasons.
>

As Tom pointed out, the value is already in memory by the time it gets
to my code. My code just reads that value from memory.

Regards,
    Jeff Davis


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: scan_recycle_buffers
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: scan_recycle_buffers