Re: [SQL] planner used functional index in 7.3.6, now does a seq

2006-11-19 Thread Chris Tennant
o get away from building postgresql from source, as I had always done previously. But I'm now a fresh convert to building from source ;-) Thanks again for your help. - Chris Tom Lane wrote: Chris Tennant <[EMAIL PROTECTED]> writes: ... the underlying problem remains: even with th

Re: [SQL] planner used functional index in 7.3.6, now does a seq

2006-11-19 Thread Chris Tennant
the 7.4 databases (I have them running on different machines). Same problem, the query executes on the 7.3 database in 0.13 ms, and on the 7.4 database in 571 ms. Tom Lane wrote: Chris Tennant <[EMAIL PROTECTED]> writes: here's the definition of the function (as immutable):

[SQL] planner used functional index in 7.3.6, now does a seq scan in 7.4.7 after upgrade

2006-11-18 Thread Chris Tennant
Greetings, I've just upgraded from 7.3.6 to 7.4.7 (running on Debian Linux). I dumped and reloaded my db as part of the upgrade. Everything is working great, except that one query that executed in < 1 ms on 7.3.6 now takes > 500 ms on 7.4.7. When I look at the query plan, the planner is no