Re: Design notes for BufMgrLock rewrite

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: Design notes for BufMgrLock rewrite
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D2FB@m0114.s-mxs.net
обсуждение исходный текст
Ответ на Design notes for BufMgrLock rewrite  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Would there be any value in incrementing by 2 for index accesses and 1
> for seq-scans/vacuums? Actually, it should probably be a ratio based on
> random_page_cost shouldn't it?

What happens with very small hot tables that are only a few pages and thus have
no index defined.

I think it would not be good to treat such data pages as less important than
index pages.

Andreas


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

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Re: Terminating a SETOF function call sequence
Следующее
От: pgsql@mohawksoft.com
Дата:
Сообщение: Re: Help me recovering data