Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 807B86325AB
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jan 2010 11:43:53 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 71538-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 10 Jan 2010 15:43:42 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ew0-f216.google.com (mail-ew0-f216.google.com
	[209.85.219.216])
	by mail.postgresql.org (Postfix) with ESMTP id 9AF3A632558
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Jan 2010 11:43:42 -0400 (AST)
Received: by ewy8 with SMTP id 8so21207376ewy.35
	for <pgsql-performance@postgresql.org>;
	Sun, 10 Jan 2010 07:43:40 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:sender:received:in-reply-to
	:references:date:x-google-sender-auth:message-id:subject:from:to:cc
	:content-type; bh=lQHgV+mVji94UckoYk0QL94+HFIN2LJBu5yNfTqx1xk=;
	b=M5oJ1htwqSGW6KSkOdqH1EaViY7iOQVdj5nGc9KompgMJCdpT+XyKISPPbIcjS9FW5
	favclQyBdqIPV+OCDNl7FGqDkHQHqQ3TpXH2Oc2rkblV9vec0t2SHnquEt6APd/Dq42E
	zWQzVqYjJ6SJCF9PeMYIHEGbse+4/P4zSSvoM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:date
	:x-google-sender-auth:message-id:subject:from:to:cc:content-type;
	b=YafGIy8k2QEL+qYJn+yuflBk3u94TuHnL3KcIpJCDl6+kuiqQhYpV74+qIDaym9+gg
	filgFva0JzFQxui3S4Qyi3uFa/B7pSfpT/u7q+VLNA/qak/k3lcG005e0Mcw7mYxabKB
	dO40+8yenF3mtCla4Yb6PEcXD1VAgWq6Nao1A=
MIME-Version: 1.0
Received: by 10.213.2.84 with SMTP id 20mr4662111ebi.46.1263138220088;
 Sun, 10
	Jan 2010 07:43:40 -0800 (PST)
In-Reply-To: <4B499B52020000250002E121@gw.wicourts.gov>
References: <4B499B52020000250002E121@gw.wicourts.gov>
Date: Sun, 10 Jan 2010 16:43:40 +0100
X-Google-Sender-Auth: 089ff5553634f4fc
Message-ID: <d4468d971001100743m383e66fes126502a973984178@mail.gmail.com>
Subject: Re: Choice of bitmap scan over index scan
From: Mathieu De Zutter <mathieu@dezutter.org>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=000e0ce0d4a0e91f1d047cd14816
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.59 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201001/177
X-Sequence-Number: 37057

--000e0ce0d4a0e91f1d047cd14816
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0ce0d4a0e91f1d047cd14816
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Sun, Jan 10, 2010 at 4:18 PM, Kevin Grittner <span dir=3D"ltr">&lt;<a hr=
ef=3D"mailto:Kevin.Grittner@wicourts.gov">Kevin.Grittner@wicourts.gov</a>&g=
t;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"border-left:=
 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex=
;">
Mathieu De Zutter =A0wrote:<br>
<br>
You didn&#39;t include any information on your hardware and OS, which can<b=
r>
be very important. =A0Also, what version of PostgreSQL is this?<br>
SELECT version(); output would be good.<br></blockquote><div><br>
Intel(R) Core(TM)2 Duo CPU=A0=A0=A0=A0 E7200=A0 @ 2.53GHz<br>
2GB RAM<br>
2x500GB RAID-1 <br>
<br>
Running Debian/Etch AMD64<br>
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<br>
<br>
Server also runs DNS/Mail/Web/VCS/... for budget reasons.<br>
Database size is 1-2 GB. Also running copies of it for testing/dev. <br>
<br>
<br>
Kind regards,<br>
Mathieu</div>

--000e0ce0d4a0e91f1d047cd14816--