bitmapscan test, no success, bs is not faster

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема bitmapscan test, no success, bs is not faster
Дата
Msg-id Pine.LNX.4.44.0504261250060.1977-300000@kix.fsv.cvut.cz
обсуждение исходный текст
Ответ на Re: Tablepartitioning: Will it be supported in Future?  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "apoc9009@yahoo.de"
Дата:
Сообщение: Re: Tablepartitioning: Will it be supported in Future?
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: [PATCHES] Continue transactions after errors in psql