what's difference between vacuum analyze and analyze?

From: leaf_yxj <leaf_yxj(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: what's difference between vacuum analyze and analyze?
Date: 2012-03-28 15:24:18
Message-ID: 1332948258361-5600887.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was asked to write a security definer function to make other user can issue
vacuum and analyze command? Friends in this community said vacuum doesn't
work inside the function or multi command. How about analyze. I know vacuum
is something much like oracle shrink which is used to reorganize the space
in the disk. Analyze is used to collect the statistic info of the table.
Does analyze works in Function or mulit-commands?

Thanks.

Regards.

Grace

--
View this message in context: http://postgresql.1045698.n5.nabble.com/what-s-difference-between-vacuum-analyze-and-analyze-tp5600887p5600887.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-03-28 15:29:46 Re: what's difference between vacuum analyze and analyze?
Previous Message Tomas Vondra 2012-03-28 15:07:43 Re: oracle linux