PgConf.Russia 2016

A backup is something that no Postgres deployments should go without as it gives the insurance to get back a deployment on its feet should a disaster strike.

In this talk we will discuss why backups are essential in any sane PostgreSQL deployments (this seems obvious) and what are the different options available to define and set up a good backup strategy. On top of that is discussed how the future of backups would need to be handled, particularly regarding differential backups that gain in popularity among users with large deployments.

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.

• the architecture
• the design and implementation of PL/pgSQL
• the difference between PL/SQL and PL/pgSQL
• the advantage and issues of PL/pgSQL

Challenges and solutions found in documents dematerialization and bank cheque processing system used in the Bank of Brazil.