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