To follow up on my own email, by disabling BitmapScan in my
postgresql.conf the performance seems to be better. Is something
wrong with the query analyzer?
v=# explain select s_content,textdir from text_search where
path_id='1' AND tb_id='P2_TB00001';
QUERY PLAN
------------------------------------------------------------------------
------------------------
Index Scan using idx_search_path_id on text_search
(cost=0.00..4081857.23 rows=5083 width=36)
Index Cond: (path_id = 1)
Filter: (tb_id = 'P2_TB00001'::text)
(3 rows)
Benjamin
On Apr 23, 2007, at 3:38 PM, Benjamin Arai wrote:
Can anybody explain to me why this query is executing so slow?
=# explain select s_content,textdir from text_search where
path_id='1' AND tb_id='P2_TB00001';
QUERY PLAN
----------------------------------------------------------------------
---------------------------
Bitmap Heap Scan on text_search (cost=39861.94..59743.55 rows=5083
width=36)
Recheck Cond: ((path_id = 1) AND (tb_id = 'P2_TB00001'::text))
-> BitmapAnd (cost=39861.94..39861.94 rows=5083 width=0)
-> Bitmap Index Scan on idx_search_path_id
(cost=0.00..16546.09 rows=1016571 width=0)
Index Cond: (path_id = 1)
-> Bitmap Index Scan on idx_search_tb_id
(cost=0.00..23315.60 rows=1016571 width=0)
Index Cond: (tb_id = 'P2_TB00001'::text)
(7 rows)
Thanks in advance!
Benjamin
---------------------------(end of
broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
