Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: " Scott Marlowe " <scott.marlowe@xxxxxxxxx>
Subject: Re: Any way to favor index scans, but not bitmap index scans?
From: "Francisco Reyes" <lists@xxxxxxxxxxxxxxxx>
Date: Wed, 23 Jul 2008 15:26:31 -0400
Cc: <tgl@xxxxxxxxxxxxx>, <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <dcc563d10807231123v5e97c955nbf61c928d85897c5@xxxxxxxxxxxxxx>
Reply-to: <lists@xxxxxxxxxxxxxxxx>

On 2:23 pm 07/23/08 "Scott Marlowe" <scott.marlowe@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Any way to favor index scans, but not bitmap index scans?
  - From: Francisco Reyes
- Re: Any way to favor index scans, but not bitmap index scans?
  - From: Tom Lane
- Re: Any way to favor index scans, but not bitmap index scans?
  - From: Francisco Reyes
- Re: Any way to favor index scans, but not bitmap index scans?
  - From: Scott Marlowe

Prev by Date: Equality search on timestamp value returns no rows
Next by Date: Re: mac install question
Previous by thread: Re: Any way to favor index scans, but not bitmap index scans?
Next by thread: Re: Any way to favor index scans, but not bitmap index scans?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux