Knowledge check

Choose the best response for each of the following questions.

Check your knowledge

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.