Re: Question about index usage

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question about index usage
Date: 2006-03-07 15:22:38
Message-ID: DC83BA52-7D59-404D-B0EF-9D2CB8C2A7A0@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07.03.2006, at 16:04 Uhr, Tom Lane wrote:

> Because IN means "=", which is a member of the index opclass for the
> second index but not the first.
>
> Why do you care? Should be about the same result either way.

Only because I haven't set up the second index because I wasn't aware
of this fact.

cug

--
PharmaLine, Essen, GERMANY
Software and Database Development

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-07 15:25:36 Re: per-statement, after, what's new?
Previous Message Tom Lane 2006-03-07 15:04:38 Re: Question about index usage