bitmapscan test, no success, bs is not faster
Pavel Stehule <stehule@kix.fsv.cvut.cz>
From: Pavel Stehule <stehule@kix.fsv.cvut.cz>
To: pgsql-hackers@postgresql.org
Date: 2005-04-26T11:20:38Z
Lists: pgsql-hackers
Attachments
- output.txt (text/plain)
- aaa.sql (text/plain)
Hello,
I tested bitmap scan and maybe I didnt find good examples, but with bitmap
scan is slower than hashjoin. Only when I use non otiptimized SELECT bps
was little bit faster. All my SELECTs are equal.
bsp off bsp on (ms)
SELECT 1 39.798 37.993
SELECT 2 0.310 0.330
SELECT 3 0.387 0.416
SQL and query plans are in attachment.
Regards
Pavel Stehule