On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir <shoaibmir@xxxxxxxxx> wrote:
On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <sathiya.psql@xxxxxxxxx> 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
