PostgreSQL 監控程式資源

1. 使用套件
• POWA
• 
  
2. 使用原生程式
• PostgreSQL Wiki1
• PostgreSQL Wiki2
• 
  
• 
  
3. 最佳化工具
• PostgreSQL Wiki
4. 部落客文章
• https://www.datadoghq.com/blog/100x-faster-postgres-performance-by-changing-1-line/
• http://www.butleranalytics.com/5-free-postgresql-dashboard-software/
• 
  
5. 官網記錄
• https://www.postgresql.org/download/products/5-reporting-tools/

PostgreSQL 監控、分析與統計工具

原始工具：

1. https://wiki.postgresql.org/wiki/9.1%E7%AC%AC%E4%BA%8C%E5%8D%81%E4%B8%83%E7%AB%A0
2. http://twpug.net/docs/postgresql-doc-8.0-zh_TW/monitoring-stats.html
3. pghero -- https://github.com/ankane/pghero
4. pgFouine -- http://pgfouine.projects.pgfoundry.org/

商用工具：

1. https://docs.citusdata.com/en/v5.1/installation/production_rhel.html
2. https://www.compose.com/articles/loading-google-analytics-data-to-postgresql-using-python/
3. http://chuansong.me/n/615176
4. http://www.it610.com/article/2662277.htm
5. http://itindex.net/detail/47304-postgres-%E6%95%B0%E6%8D%AE%E5%BA%93-%E5%88%86%E6%9E%90

問題與討論

1. 索引問題：http://stackoverflow.com/questions/3318727/postgresql-index-usage-analysis

PostgreSQL 有用的文章

1. http://conbar.pixnet.net/blog/post/9618904-(%E6%95%B4%E7%90%86%E4%B8%AD)enterprisedb-vs.-oracle%E8%B3%87%E6%96%99%E5%BA%AB%E7%9B%B8%E7%95%B0%E8%99%95%E6%AF%94%E8%BC%83--
2. http://postgresql-chinese.blogspot.tw/2007/03/postgresql-tablespace.html
3. http://postgresql.wisdomfish.org/zi-liao-ku-de-he-xin-li-lun-yu-shi-wu/ch-zi-liao-ku-lun-shu