Re: [HACKERS] Proposal: Improve bitmap costing for lossy pages

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Proposal: Improve bitmap costing for lossy pages
Дата
Msg-id CA+Tgmoa7hxMBDVmWSajs4DjqXGtKvCQUqrAbEe9m8ZOxqJSsag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Proposal: Improve bitmap costing for lossy pages  (Dilip Kumar <dilipbalaut@gmail.com>)
Ответы Re: [HACKERS] Proposal: Improve bitmap costing for lossy pages  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Sun, Sep 17, 2017 at 7:04 AM, Dilip Kumar <dilipbalaut@gmail.com> wrote:
> I used  lossy_pages = max(0, total_pages - maxentries / 2). as
> suggesed by Alexander.

Does that formula accurately estimate the number of lossy pages?

The performance results look good, but that's a slightly different
thing from whether the estimate is accurate.

+    nbuckets = tbm_calculate_entires(maxbytes);

entires?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Mario Fernando Guerrero Díaz
Дата:
Сообщение: Re: [HACKERS] Postgres 9.6 Logical and Fisical replication
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Allow multiple tables to be specified in one VACUUM or ANALYZE c