From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Andriy Tkachuk <ant(at)imt(dot)com(dot)ua> |
Cc: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: query speed depends on lifetime of frozen db? |
Date: | 2002-09-27 09:20:07 |
Message-ID: | 20020927092007.GA21756@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(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.
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2002-09-27 09:39:05 | Re: multi-database |
Previous Message | Andriy Tkachuk | 2002-09-27 08:49:08 | Re: query speed depends on lifetime of frozen db? |
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Chittenden | 2002-09-27 09:22:55 | Re: Web site |
Previous Message | Andriy Tkachuk | 2002-09-27 08:49:08 | Re: query speed depends on lifetime of frozen db? |