If this is a query that will be executed more than once, you can also avoid incurring the planning overhead multiple times by using PREPARE. -- Mark Lewis On Wed, 2006-01-11 at 18:50 -0500, Jean-Philippe Côté wrote: > Thanks a lot for this info, I was indeed exceeding the genetic > optimizer's threshold. Now that it is turned off, I get > a very stable response time of 435ms (more or less 5ms) for > the same query. It is about three times slower than the best > I got with the genetic optimizer on, but the overall average > is much lower. > > I'll also try to play with the geqo parameters and see if things > improve. > > Thanks again, > > J-P
