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

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 (view raw or flat)
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

pgsql-novice by date

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

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