Re: [HACKERS] Large databases, performance

On 3 Oct 2002 at 18:53, Manfred Koizar wrote:

> On Thu, 03 Oct 2002 21:47:03 +0530, "Shridhar Daithankar"
> <shridhar_daithankar@persistent.co.in> wrote:
> >I believe that was vacuum analyze only.
> 
> Well there is
> 
> 	VACUUM [tablename]; 
> 
> and there is
> 
> 	ANALYZE [tablename];
> 
> And
> 
> 	VACUUM ANALYZE [tablename];
> 
> is VACUUM followed by ANALYZE.

I was using vacuum analyze. 

Good that you pointed out. Now I will modify the postgresql auto vacuum daemon 
that I wrote to analyze only in case of excesive inserts. I hope that's lighter 
on performance compared to vacuum analyze..

Bye
 Shridhar

--
Mix's Law:	There is nothing more permanent than a temporary building.	There is 
nothing more permanent than a temporary tax.