that sometimes executes fast and sometimes
hangs for hours until we kill the process.
yours,
- clifford
--
: Clifford Wolf Tel +43-1-8178292-00 :
: LINBIT Information Technologies GmbH Fax +43-1-8178292-82 :
: Schönbrunnerstr 244, 1120 Vienna, Austria
'CREATE INDEX clifford_temp ON contractelements ( upper(isActiv) )' followed
by an 'ANALYZE contractelements' solves the
problem in this particular case. But this is not a solution to the problem in
general..
Shouldn't the query planner be able to do the right thing wit
'Y'
) WITH SELECTIVITY 0.9
AND loc.shortName = '5195'
However, it would be great to have get_restriction_variable() and
get_attstatsslot() extended so they can pass the most common values
from the statistics cache thru expressions, as described in my earlier
mail.
yours,
Hi,
On Wednesday 01 February 2006 18:19, you wrote:
> Clifford Wolf <[EMAIL PROTECTED]> writes:
> > However, it would be great to have get_restriction_variable() and
> > get_attstatsslot() extended so they can pass the most common values
> > from the statistics
