Postgres Pro
Downloads
Home   >   mailing lists

Re: seqscan instead of index scan - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: seqscan instead of index scan
Date
Msg-id 20040830191805.GA1521@wolff.to
Whole thread Raw
In response to Re: seqscan instead of index scan  (Martin Sarsale <martin@emepe3.net>)
List pgsql-performance
Tree view 
On Mon, Aug 30, 2004 at 15:07:15 -0300,
  Martin Sarsale <martin@emepe3.net> wrote:
>
> With combined index, you mean a multiple column index?
> From
> http://www.postgresql.org/docs/7.4/interactive/indexes-multicolumn.html

You are right, a multicolumn index doesn't help for 'or'.

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: seqscan instead of index scan
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Why does a simple query not use an obvious index?