ANALYZE command question
Started by Igor Stassiyabout 11 years ago2 messagesgeneral
Hi,
Will calling ANALYZE table; twice in a row actually run the command twice ?
Or there is some sort of check that if the table is not changed since the
time of first call the second command will not actually be run?
Thanks,
Igor
Re: ANALYZE command question
Igor Stassiy wrote:
Will calling ANALYZE table; twice in a row actually run the command twice ? Or there is some sort of
check that if the table is not changed since the time of first call the second command will not
actually be run?
The statistics will be calculated each time you run ANALYZE.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general