Where clause limited to 8 items?

From: "Henry Combrinck" <henry(at)metroweb(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Where clause limited to 8 items?
Date: 2004-10-20 00:27:29
Message-ID: 57276.168.210.90.180.1098232049.squirrel@airmail.metroweb.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

Searched around, but could not find this mentioned.

I've noticed the following behaviour in 7.4.5:

[explain analyse] select * from foo where
col1 = 1 or
col1 = 2 or
col1 = 3 or
col1 = 4 or
col1 = 5 or
col1 = 6 or
col1 = 7 or
col1 = 8;

where an index on foo.col1 exists.

The above works fine - the index is used. However, extend the where
clause with an extra line (say, col1 = 9) and the index is no longer used.

Is there a parameter I can SET to extend the number of items allowed for
index usage?

Any pointers would be appreciated.

Henry

--------------------------------------------------------
This message was sent using MetroWEB's AirMail service.
http://www.metroweb.co.za/ - full access for only R73.
Free Web Accelerator, WebMail, Calendar, Anti-Virus,
Anti-Spam, 10 emails, 100MB personal webspace, and more!
Phone Now! 086 11 11 440

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Weiping 2004-10-20 00:49:29 Re: About upper() and lower to handle multibyte char
Previous Message Mike Nolan 2004-10-20 00:16:08 Re: How do I recover from>> pg_xlog/0000000000000000 (log