Re: forcing pg to use an index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: forcing pg to use an index
Date: 2007-06-09 19:27:03
Message-ID: 3101.1181417223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com> writes:
> CREATE INDEX domain_alexa_stock_ticker_dom ON domain_dom
> USING btree (alexa_contactinfo___companystockticker___symbol_dom)
> WHERE NOT alexa_contactinfo___companystockticker___symbol_dom IS NULL;

Try spelling that as "foo is not null", instead. There's a limit to the
complexity of the planner's predicate-proving ability ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Lefevre 2007-06-11 01:33:12 disallowed characters in table names?
Previous Message David Monarchi 2007-06-09 18:01:50 forcing pg to use an index