Mike Christensen m...@kitchenpc.com writes:
Thanks! One thing that still confuses me is the difference between IN
and OR. With this query:
explain analyze
select *
from foobar
where d in (500, 750);
It scans the d index only once:
'Bitmap Heap Scan on foobar (cost=10.03..400.63
Hi -
I'm trying to increase my general knowledge about how indexes work in
databases. Though my questions are probably general and implemented
in a similar way across major relational DBs, I'm also curious as to
how they're implemented in Postgres specifically (mainly because I
like PG, and am
To: pgsql-general@postgresql.org
Subject: [GENERAL] I'd like to learn a bit more about how indexes work
Hi -
I'm trying to increase my general knowledge about how indexes work in
databases. Though my questions are probably general and implemented in a
similar way across major relational DBs, I'm also
such as:
sql cost based optimizer
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen
Sent: Tuesday, June 05, 2012 3:25 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] I'd like to learn a bit
-Original Message-
From: Mike Christensen [mailto:m...@kitchenpc.com]
Sent: Tuesday, June 05, 2012 4:28 PM
To: Dann Corbit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] I'd like to learn a bit more about how indexes work
I'm aware of how B-Trees work, but I only understand them
On Tue, Jun 5, 2012 at 6:24 PM, Mike Christensen m...@kitchenpc.com wrote:
Hi -
I'm trying to increase my general knowledge about how indexes work in
databases. Though my questions are probably general and implemented
in a similar way across major relational DBs, I'm also curious as to
how
On Tue, Jun 5, 2012 at 7:20 PM, Chris Curvey ch...@chriscurvey.com wrote:
On Tue, Jun 5, 2012 at 6:24 PM, Mike Christensen m...@kitchenpc.com wrote:
Hi -
I'm trying to increase my general knowledge about how indexes work in
databases. Though my questions are probably general and