Postgres Pro
Downloads
Home   >   mailing lists

Re: bitmap-index-scan slower than normal index scan - Mailing list pgsql-performance

From A. Kretschmer
Subject Re: bitmap-index-scan slower than normal index scan
Date
Msg-id 20070711193158.GA28352@a-kretschmer.de
Whole thread Raw
In response to Re: bitmap-index-scan slower than normal index scan  ("Alex Deucher" <alexdeucher@gmail.com>)
Responses Re: bitmap-index-scan slower than normal index scan  ("Alex Deucher" <alexdeucher@gmail.com>)
List pgsql-performance
Tree view 
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.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: WALL on controller without battery?
Next
From: Francisco Reyes
Date:
Subject: Re: WALL on controller without battery?