Tomas Vondra, PostgreSQL Database Engineer at 2ndQuadrant, presented a webinar on CREATE STATISTICS command in PostgreSQL. The command was initially introduced in PostgreSQL 10 and saw further improvements in PostgreSQL 12. This command allows the database to collect multi-column statistics which helps the optimizer understand dependencies between columns, produces more accurate estimates and...

Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate such risks. Martín Marqués, Head of Support Operations at 2ndQuadrant, hosted a webinar on backup and disaster recovery options in PostgreSQL. The webinar: “ You forgot to put the WHERE in DELETE?” was held on 11 Dec...