Postgres Pro
Downloads
Home   >   mailing lists

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

From Pierre-Frédéric Caillaud
Subject Re: seqscan instead of index scan
Date
Msg-id opsdj8vrsacq72hf@musicbox
Whole thread Raw
In response to Re: seqscan instead of index scan  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
Tree view 
>> create index t_idx on t((c+d));
>> select * from t where c+d > 0;

    Why not :

    select ((select * from t where c<>0::bigint) UNION (select * from t where
d<>0::bigint))
    group by whatever;

    or someting ?

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Why does a simple query not use an obvious index?
Next
From: Stephan Szabo
Date:
Subject: Re: seqscan instead of index scan