Re: query speed depends on lifetime of frozen db?

On Fri, Sep 27, 2002 at 12:50:14PM +0300, Andriy Tkachuk wrote:
> On Fri, 27 Sep 2002, Martijn van Oosterhout wrote:
>
> > On Fri, Sep 27, 2002 at 11:49:08AM +0300, Andriy Tkachuk wrote:
> > > On Fri, 27 Sep 2002, Shridhar Daithankar wrote:
> > > > was that vacuum full or vacuum analyze? Vacuum full should help in this case..
> > >
> > > it was full with analize
> > > That's what i want to say, that this is very strange for me that vacuum
> > > not helpfull in this situation!
> >
> > Ok, can you post the result of VACUUM FULL VERBOSE ANALYSE ?

<snip>

Um, from the looks of that output, it seems your entire DB is less than 2MB,
right? So it should be totally cached. So it must be your query at fault.
What is the output of EXPLAIN ANALYSE <query>;

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.