Re: Choice of bitmap scan over index scan - Mailing list pgsql-performance

From Mathieu De Zutter
Subject Re: Choice of bitmap scan over index scan
Date
Msg-id d4468d971001100743m383e66fes126502a973984178@mail.gmail.com
Whole thread Raw
In response to Re: Choice of bitmap scan over index scan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On Sun, Jan 10, 2010 at 4:18 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
Mathieu De Zutter  wrote:

You didn't include any information on your hardware and OS, which can
be very important.  Also, what version of PostgreSQL is this?
SELECT version(); output would be good.

Intel(R) Core(TM)2 Duo CPU     E7200  @ 2.53GHz
2GB RAM
2x500GB RAID-1

Running Debian/Etch AMD64
PG version: PostgreSQL 8.3.8 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2

Server also runs DNS/Mail/Web/VCS/... for budget reasons.
Database size is 1-2 GB. Also running copies of it for testing/dev.


Kind regards,
Mathieu

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Choice of bitmap scan over index scan
Next
From: "Kevin Grittner"
Date:
Subject: Re: Choice of bitmap scan over index scan