X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 88D9F9DCAB2 for ; Thu, 15 Dec 2005 04:15:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37065-01 for ; Thu, 15 Dec 2005 04:15:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [203.96.152.180]) by postgresql.org (Postfix) with ESMTP id E0C559DCA8C for ; Thu, 15 Dec 2005 04:15:10 -0400 (AST) Received: from smtp-1.paradise.net.nz (tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IRJ00K6R5LA9N@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Thu, 15 Dec 2005 21:15:10 +1300 (NZDT) Received: from [192.168.1.11] (218-101-28-129.dsl.clear.net.nz [218.101.28.129]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id 809A94A786F; Thu, 15 Dec 2005 21:15:09 +1300 (NZDT) Date: Thu, 15 Dec 2005 21:15:05 +1300 From: Mark Kirkwood Subject: Re: Simple Join In-reply-to: <200512150146.06336.blargity@gmail.com> To: Kevin Brown Cc: pgsql-performance@postgresql.org Message-id: <43A12609.70208@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (X11/20051106) References: <200512141603.52583.blargity@gmail.com> <200512141752.45866.blargity@gmail.com> <43A0BA70.8000802@paradise.net.nz> <200512150146.06336.blargity@gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.167 required=5 tests=[AWL=0.167] X-Spam-Score: 0.167 X-Spam-Level: X-Archive-Number: 200512/352 X-Sequence-Number: 16173 Kevin Brown wrote: > On Wednesday 14 December 2005 18:36, you wrote: > >>Well - that had no effect at all :-) You don't have and index on >>to_ship.ordered_product_id do you? - try adding one (ANALYZE again), and >>let use know what happens (you may want to play with SET >>enable_seqscan=off as well). > > > I _DO_ have an index on to_ship.ordered_product_id. It's a btree. > Sorry - read right past it! Did you try out enable_seqscan=off? I'm interested to see if we can get 8.1 bitmap anding the three possibly useful columns together on ordered_products and *then* doing the join to to_ship. Cheers Mark