Re: [PATCHES] Bitmap index scan preread using posix_fadvise (Was: There's random access and then there's random access)

Nice! - Luke On 1/30/08 9:22 AM, "Gregory Stark" <[EMAIL PROTECTED]> wrote: > > Here's the WIP patch for doing prereading when doing bitmap index scans. > > I was performance testing it as I was developing it here: > > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00395.php > > No

[PATCHES] Bitmap index scan preread using posix_fadvise (Was: There's random access and then there's random access)

Here's the WIP patch for doing prereading when doing bitmap index scans. I was performance testing it as I was developing it here: http://archives.postgresql.org/pgsql-hackers/2007-12/msg00395.php Note that this only kicks in for bitmap index scans which are kind of tricky to generate. I used t