Re: count * performance issue

will you please tell, what is autovacuuming... and wat it ll do... is there
any good article in this....

On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:

> On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <sathiya(dot)psql(at)gmail(dot)com>
> wrote:
>
> > buy every time i need to put ANALYZE...
> > this takes the same time as count(*) takes, what is the use ??
> >
> >
> >
> Dont you have autovacuuming running in the background which is taking care
> of the analyze as well?
>
> If not then hmm turn it on and doing manual analyze then shouldnt I guess
> take much time!
>
> But yes, I will say if its possible go with the trigger option as that
> might be more helpful and a very fast way to do that.
>
>
> --
> Shoaib Mir
> Fujitsu Australia Software Technology
> shoaibm[(at)]fast(dot)fujitsu(dot)com(dot)au
>