Re: query speed depends on lifetime of frozen db?

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 ?

> >
> > Is it that some tables with few rows gets updated heavily causing lot of dead
> > tuples? May be 2 hour is bit too long before vacuum should be called. Try
> > running table speific vacuum more periodically..
>
> As I said there was no work with this test database during the time after which
> query becomes overloading. There was just work with another databases.

Well, something is happening. The verbose in the above command should help.

--
Martijn van Oosterhout   <kleptog@svana.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.