ArcGIS Server Banner

Updating geodatabase statistics in PostgreSQL databases

Updating geodatabase statistics in PostgreSQL databases

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

PostgreSQL documentation recommends that most sites run the ANALYZE command on a daily basis to update database statistics and that it should be run when few or no users are accessing the database. You can run the PostgreSQL ANALYZE command by itself or along with the VACUUM command. Since you should also run the PostgreSQL VACUUM command on a regular basis to recover disk space, you might want to include an ANALYZE command with the VACUUM command.

You can script this to run nightly, when it is likely that fewer users would be connecting to the database. There is also an autovacuum option available. Consult the PostgreSQL documentation at http://www.postgresql.org/docs for details on the ANALYZE command, VACUUM command, and autovacuum option.

You can also update statistics using the sdetable &o update_statistics command. The syntax for this command is as follows:

sdetable -o update_dbms_stats &t <table_name> [–K <keyword>]
[–m {VACUUM | VACUUM_FULL}] [–n {ALL | <index_name>}]
[–i <service>] [–s <server_name>] [–D <database>]
–u <DB_user_name> [–p <DB_user_password>] [–N] [–q]

For details on running the sdetable command, consult the ArcSDE Administration Command Reference provided with the ArcSDE component of ArcGIS Server Enterprise.

See Also

  • About updating geodatabase statistics