Knowledge check

1.

Which schema stores metadata in PostgreSQL?

pg_schema

pg_catalog

pg_metadata

2.

Which system table contains lock information for each database?

pg_database.

pg_stat_database.

pg_database_lock.

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?

Split the table into two.

Increase the value for autovacuum_analyze_threshold.

Disable AUTOVACUUM and run VACUUM manually as required.

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?

Check the server parameters to ensure autovacuum is switched OFF.

Prevent users from adding more data to the database until the problem is solved.

Run a SELECT query to find dead rows that are no longer needed in the database.

Check your knowledge

Feedback