Re: count * performance issue

------=_Part_3575_32352525.1204785069168
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@[EMAIL PROTECTED]
> wrote:

> On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <sathiya.psql@[EMAIL PROTECTED]
>
> 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[@[EMAIL PROTECTED]
>

------=_Part_3575_32352525.1204785069168
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

will you please tell, what is autovacuuming... and wat it ll do... is
there any good article in this....<br><br><div class="gmail_quote">On Thu,
Mar 6, 2008 at 11:56 AM, Shoaib Mir &lt;<a
href="mailto:shoaibmir@[EMAIL PROTECTED]
">shoaibmir@[EMAIL PROTECTED]
>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="Ih2E3d">On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql &lt;<a
href="mailto:sathiya.psql@[EMAIL PROTECTED]
"
target="_blank">sathiya.psql@[EMAIL PROTECTED]
>&gt; wrote:<br>
</div><div class="gmail_quote"><div class="Ih2E3d"><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
buy every time i need to put ANALYZE...<br>this takes the same time as
count(*) takes, what is the use
??<div><div></div><div><br><br></div></div></blockquote></div><div><br>Dont
you have autovacuuming running in the background which is taking care of
the analyze as well?<br>

<br>If not then hmm turn it on and doing manual analyze then shouldnt I
guess take much time!<br></div></div><br>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.<div>
<div></div><div class="Wj3C7c"><br>
<br>-- <br>Shoaib Mir<br>Fujitsu Australia Software
Technology<br>shoaibm[@[EMAIL PROTECTED]
></div></blockquote></div><br>

------=_Part_3575_32352525.1204785069168--