From: | "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com> |
---|---|
To: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
Cc: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: count * performance issue |
Date: | 2008-03-06 06:31:09 |
Message-ID: | f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2008-03-06 06:32:50 | Re: count * performance issue |
Previous Message | Mark Mielke | 2008-03-06 06:26:46 | Re: count * performance issue |