Knowledge check

  • 3 minutes

Choose the best response for each of the following questions. Then select Check your answers.

Check your knowledge

1.

Which schema stores metadata in PostgreSQL?

2.

Which system table contains lock information for each database?

3.

The server parameters are tuned to make autovacuum more efficient. However, users are complaining of slight delays when updating the single table in the database that has most updates. What needs done to resolve the problem?

4.

A new administrator recently took over support for an Azure Database for PostgreSQL database at the company. It was noticed that the storage required for the database seems to be growing faster than expected. What steps should be taken to investigate?