Re: [GENERAL] help understanding the bitmap heap scan costs

2012-05-21 Thread Cédric Villemain
Le lundi 21 mai 2012 15:35:55, Luca Ferrari a écrit : > Hi all, > I don't fully understand how is the cost of a bitmap heap scan > computed. For instance when the explain output node is similar to the > following: > > Bitmap Heap Scan on test (cost=17376.49..48595.93 rows=566707 width=6) >Re

[GENERAL] help understanding the bitmap heap scan costs

2012-05-21 Thread Luca Ferrari
Hi all, I don't fully understand how is the cost of a bitmap heap scan computed. For instance when the explain output node is similar to the following: Bitmap Heap Scan on test (cost=17376.49..48595.93 rows=566707 width=6) Recheck Cond: ((text1 = 'A'::text) OR (text1 = 'C'::text)) Filter: