Re: query speed depends on lifetime of frozen db?

On Fri, 27 Sep 2002, Martijn van Oosterhout wrote:

> On Fri, Sep 27, 2002 at 01:28:13PM +0300, Andriy Tkachuk wrote:
> > On Fri, 27 Sep 2002, Martijn van Oosterhout wrote:
> > > What is the output of EXPLAIN ANALYSE <query>;
> >
> > There is EXPLAIN ANALYSE when query is heavy:
>
> Oookaaay. Your query is *evil*. 14 subqueries executed for *each* row of
> output!?! I reackon you could improve your query just by rewriting it into a
> better form. How can you have 10 subqueries to the same table?
>
> Anyway, the only thing that seems to change is the statistics, which leads
> me to beleive that all that is happening is that the planner is reordering some
> of your clauses causing it to execute expensive ones it may otherwise be
> able to avoid. In your case the default statistics do better than the real
> ones.

YES! You right!
Just after restirong db i made vacuumdb -z -f
and query become heavy!

Does one have any ideas how to ovecome this!?

Thanks a lot Martijn,
Andriy.