This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the following questions.
Which schema stores metadata in PostgreSQL?
pg_schema
pg_catalog
pg_metadata
Which system table contains lock information for each database?
pg_database.
pg_stat_database.
pg_database_lock.
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.
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.
You must answer all questions before checking your work.
Was this page helpful?