Re: Any way to favor index scans, but not bitmap index scans?

From: "Francisco Reyes" <lists(at)stringsutils(dot)com>
To: " Scott Marlowe " <scott(dot)marlowe(at)gmail(dot)com>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Any way to favor index scans, but not bitmap index scans?
Date: 2008-07-23 19:26:31
Message-ID: 34547f1a1d5d6ed81487cf29ed0a4e59@stringsutils.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2:23 pm 07/23/08 "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:
> > However, I do have a current example where bitmap index scan was 3
> > times worse.

> What is your work_mem set to?

For the examples that I posted it is
work_mem = 64MB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2008-07-23 19:28:15 Re: mac install question
Previous Message Keaton Adams 2008-07-23 19:24:26 Equality search on timestamp value returns no rows