Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id ED44A9FB208 for ; Wed, 11 Jul 2007 17:01:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 67319-08 for ; Wed, 11 Jul 2007 17:01:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.239]) by postgresql.org (Postfix) with ESMTP id 62F519FA5BF for ; Wed, 11 Jul 2007 17:01:37 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1298444nzf for ; Wed, 11 Jul 2007 13:01:34 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=mVdxC9qqd07LAkp26zoCuPScfbfDNGvj5p1fMBMrVnULrVIkmEskfCw/dGwr79Ak6WI91Lzj9GltwN65EJBsgwg4SbxjM9Szi/aXlgjI/B7GTJsMIxHAuDMODB7PdiaPfr2/+yG5GfFhbyGjYFMP0UT2mtWH+5j5nd/wIgD7D0A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=GgLDUr+daezDwIaVNrnzZk2YxKJNfzwC6aSQZhG48Y3J544wimBgAF/rfLsJksGmSvHbRFNpp1ZPkwLb3lOpcNDDeU81iBPKanHQLKprsNSI0DFt/Zk8p4hiG2twQYFDmjS/hlcQNwSd66opgWSUg+l6IwyqbRbp94iKFj8gw5w= Received: by 10.141.162.16 with SMTP id p16mr1714741rvo.1184184090859; Wed, 11 Jul 2007 13:01:30 -0700 (PDT) Received: by 10.140.252.21 with HTTP; Wed, 11 Jul 2007 13:01:30 -0700 (PDT) Message-ID: Date: Wed, 11 Jul 2007 16:01:30 -0400 From: "Alex Deucher" To: "A. Kretschmer" Subject: Re: bitmap-index-scan slower than normal index scan Cc: pgsql-performance@postgresql.org In-Reply-To: <20070711193158.GA28352@a-kretschmer.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070711183638.GA30872@KanotixBox> <20070711193158.GA28352@a-kretschmer.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/118 X-Sequence-Number: 25802 On 7/11/07, A. Kretschmer wrote: > am Wed, dem 11.07.2007, um 14:52:01 -0400 mailte Alex Deucher folgendes: > > >Okay, i got a really different plan, but i expected _NOT_ a > > >performance-boost like this. I expected the opposite. > > > > > > > > >It's not a really problem, i just played with this. But i'm confused > > >about this... > > > > > > > your results are getting cached. try two queries in a row with the same > > plan. > > Thanks for the response, but I've done this, no difference. > try bumping up the default stats target on the table in question and see if that helps the planner choose a better plan. Alex