Re: [PERFORM] query planner and scanning methods

2008-09-23 Thread Colin Copeland
On Sep 23, 2008, at 6:07 PM, Richard Broersma wrote: On Tue, Sep 23, 2008 at 2:22 PM, Colin Copeland <[EMAIL PROTECTED] > wrote: dimension=# EXPLAIN ANALYZE SELECT DISTINCT ON ("dimension_book"."call") "dimension_book"."title&quo

[PERFORM] query planner and scanning methods

2008-09-23 Thread Colin Copeland
1) Recheck Cond: (library_id = ANY ('{12,15,20}'::integer[])) -> Bitmap Index Scan on dimension_library_books_library_id (cost=0.00..3898.30 rows=211789 width=0) (actual time=95.030..95.030 rows=426156 loops=1)