Storage Internals: Pages Quiz Home › PostgreSQL DBA › Storage Internals: Pages 📦 Postgres Database Administration – Storage Internals: Pages 20 questions · 15 min timer · Explanations included · Free 1. Which of the following is a potential drawback of not maintaining the Free Space Map in PostgreSQL? Increased risk of data corruption. Automatic deletion of old tuples. Loss of database connectivity. Decreased query performance due to inefficient space utilization. None Show Hint Not maintaining the Free Space Map in PostgreSQL can lead to inefficient space utilization, as the system may not be able to quickly find pages with available space for new tuples, resulting in decreased query performance. 2. What happens when a page in PostgreSQL becomes full and a new tuple needs to be inserted? The database automatically increases the page size. The database triggers a vacuum operation to free up space. The system performs a page split to accommodate the new tuple. The tuple is stored in a new page, and the FSM is updated. None Show Hint When a page is full, PostgreSQL will store the new tuple in a different page with available space, as tracked by the FSM. This avoids the need for page splits, which are not a feature of PostgreSQL's storage model. Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Click Submit to see your final score! Previous Start Quiz Next Time's up
