PgConf.Russia 2016

In the speech we consider the current PostgreSQL planner model, then the possibilities of applying machine learning methods for planner improvement and the obtained results.

• First aquaintance
• Fight with replication
• Partitioning and migration
• Cross data-center use
• v8, json, jsonb, jsquery
• Version upgrade

Method of automated refresh of preprocessed results of analytis reports is provided. Preprocessing and caching of reports allows ability for fast response for big data reports. Author describes the way of reports cache refreshing with minimum server loads and tuned actualization rate.