Mike Christensen 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 rows=196 width=1
On Tue, Jun 5, 2012 at 7:20 PM, Chris Curvey wrote:
>
>
> On Tue, Jun 5, 2012 at 6:24 PM, Mike Christensen 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 acro
On Tue, Jun 5, 2012 at 6:24 PM, Mike Christensen 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 they're impl
-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, b
l-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 more about how indexes work
>
> Hi -
>
> I'm trying to increase my general knowl
Tuesday, June 05, 2012 3:25 PM
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
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 al
