Re: count * performance issue

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

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]
 text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql &lt;<a
href="mailto:sathiya.psql@[EMAIL PROTECTED]
">sathiya.psql@[EMAIL PROTECTED]
>&gt;
wrote:<br><div class="gmail_quote"><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
class="Wj3C7c"><br><br></div></div></blockquote><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.<br>
<br>-- <br>Shoaib Mir<br>Fujitsu Australia Software
Technology<br>shoaibm[@[EMAIL PROTECTED]