Postgres Pro
Downloads
Home   >   mailing lists

Re: count * performance issue - Mailing list pgsql-performance

From sathiya psql
Subject Re: count * performance issue
Date
Msg-id f966c2ee0803052231o28613b16w2197e713d7654642@mail.gmail.com
Whole thread Raw
In response to Re: count * performance issue  ("Shoaib Mir" <shoaibmir@gmail.com>)
Responses Re: count * performance issue
List pgsql-performance
Tree view
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@gmail.com> wrote:
On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <sathiya.psql@gmail.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[@]fast.fujitsu.com.au

pgsql-performance by date:

Previous
From: Mark Mielke
Date:
Subject: Re: count * performance issue
Next
From: "Shoaib Mir"
Date:
Subject: Re: count * performance issue