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 of the following best describes the architecture of PostgreSQL?
Client/server.
Distributed.
Relational.
You run a few complex queries on your PostgreSQL database. Which server parameter should you consider tuning to improve performance?
work_mem
max_connection
Shared_buffers
Which server process is responsible for initiating and shutting down the PostgreSQL processes?
Query optimizer.
Postmaster daemon.
PostgreSQL backend processes.
You must answer all questions before checking your work.
Was this page helpful?