bitmapscan test, no success, bs is not faster - Mailing list pgsql-hackers

From Pavel Stehule
Subject bitmapscan test, no success, bs is not faster
Date
Msg-id Pine.LNX.4.44.0504261250060.1977-300000@kix.fsv.cvut.cz
Whole thread Raw
In response to Re: Tablepartitioning: Will it be supported in Future?  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses Re: bitmapscan test, no success, again  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Re: bitmapscan test, no success, bs is not faster  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: "apoc9009@yahoo.de"
Date:
Subject: Re: Tablepartitioning: Will it be supported in Future?
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: [PATCHES] Continue transactions after errors in psql