Re: [HACKERS] speedup tidbitmap patch: cache page

[Teodor Sigaev]

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?


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

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.

tbm_cachepage-2.2.patch.gz
Description: GNU Zip compressed data

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