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]