On Wed, Dec 2, 2009 at 11:13 AM, Laurent Laborde <kerdezixe@xxxxxxxxx> wrote: >> QUERY PLAN >> ----------------------------------------------------------------------------------------------------- >> Limit (cost=66114.13..66115.38 rows=500 width=1114) >> -> Sort (cost=66114.13..66157.37 rows=17296 width=1114) >> Sort Key: id >> -> Bitmap Heap Scan on _article (cost=138.32..65252.29 >> rows=17296 width=1114) >> Recheck Cond: (bitfield && B'1'::bit varying) >> -> Bitmap Index Scan on idx_article_bitfield >> (cost=0.00..134.00 rows=17296 width=0) >> Index Cond: (bitfield && B'1'::bit varying) Uhm, what kind of index is idx_article_bitfield? -- greg -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
