Skip site navigation (1) Skip section navigation (2)

Re: WHERE clause with 40+ conditions

From: DrYSG <ygutfreund(at)draper(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: WHERE clause with 40+ conditions
Date: 2012-05-07 14:22:09
Message-ID: 1336400529712-5691174.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
My issue is I am also not a DB guy, but a software guy.

So while I appreciate the idea of a 40 bit field, that I would use as a mask
to test against the query (an AND would do very nicely). I wonder if this
would work well in a DB with 20M+ records in the table.

The other fields (type, producer, etc.) are indexed as a B-Tree, but if one
indexed this field, it is not clear to me if the DB planner would do an
effective search. (that is what I do not know).



--
View this message in context: http://postgresql.1045698.n5.nabble.com/WHERE-clause-with-40-conditions-tp5686659p5691174.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Responses

pgsql-novice by date

Next:From: Daniel StaalDate: 2012-05-07 15:06:11
Subject: Re: WHERE clause with 40+ conditions
Previous:From: Merlin MoncureDate: 2012-05-07 14:11:23
Subject: Re: execute stored function from ms visual foxpro

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group