Re: speedup tidbitmap patch: cache page

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: speedup tidbitmap patch: cache page
Дата
Msg-id 5491A7C0.20708@sigaev.ru
обсуждение исходный текст
Ответ на Re: speedup tidbitmap patch: cache page  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: speedup tidbitmap patch: cache page  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
> You could well be right, but it would be good to compare the numbers just so we
> know this for sure.
I wasn't right :(

# set work_mem='64kB';
# set enable_seqscan  = off;
Patched: 1194.094 ms
Master:  1765.338 ms

 > Are you seeing the same?
Fixed too, the mistake was in supposition that current page becomes lossy in
tbm_lossify. It's not always true because tbm_lossify() could lossify only part
of pages and we don't know which. Thank you very much.

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

Вложения

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

Предыдущее
От: didier
Дата:
Сообщение: Re: WALWriter active during recovery
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Proposal: Log inability to lock pages during vacuum