[PERFORM] Migration study, step 2: rewriting queries

2006-04-16 Thread Mikael Carneholm
Since my first post in this series, data has been successfully exported from the proprietary db (in CSV format) and imported into postgres (PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)) using COPY. The tablespace holding the tables+indexes is no

Re: [PERFORM] Migration study, step 2: rewriting queries

2006-04-16 Thread Tom Lane
"Mikael Carneholm" <[EMAIL PROTECTED]> writes: > ..and this last AND seems unnessecary, since the predicate on > (driver_activity_type__id = 5) is included in each of the above > conditions. This should be fixed by the changes I made recently in choose_bitmap_and --- it wasn't being aggressive abo