The following PostgreSQL statements will ensure that auto-vacuum vacuum and analyze are run every 1000 updates (inserts, modifies, or deletes) on the tables that are usually the biggest in the Cloud Manager Application Server installation. The threshold should be set to 1000 for both the vacuum and analyze threshold settings. The scale factor should be set to zero for both vacuum and analyze auto-vacuum settings. Performance degrades significantly before the auto-vacuum vacuuming and analyzing occurs. The default auto-vacuum analyze and vacuum settings are sufficient for a small deployment, but the percentage thresholds take longer to trigger as the tables grow larger. That same table is auto-analyzed when 1050 rows are inserted, updated, or deleted. For example, a table with 10000 rows is not auto-vacuumed until 2050 rows are inserted, updated, or deleted. Tables are auto-analyzed when a threshold is met for 10% of the rows plus 50 rows. PostgreSQL database tables are auto-vacuumed by default when 20% of the rows plus 50 rows are inserted, updated, or deleted. Vacuuming cleans up stale or temporary data in a table, and analyzing refreshes its knowledge of all the tables for the query planner. Performance can degrade significantly if stale and temporary data are not systematically removed. In a large-scale datacenter, the tables in the Application Server PostgreSQL database can grow quite large.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |