Tips and tricks for speeding up PostgreSQL in an automated testing environment

Bennie Swart PostgresConf South Africa 2019 https://postgresconf.org/conferences/SouthAfrica2019/program/proposals/tips-and-tricks-for-speeding-up-postgresql-in-an-automated-testing-environment In an automated testing environment it is often a requirement to create a clean database for each group of tests, but creating and initializing new databases can be slow and resource intensive. In this talk we will look at a collection of tips and tricks to optimize the setup and teardown of new databases in an effort to significantly reduce the overall execution time of tests.