Partitioning: Declarative vs. Inheritance-based Quiz Home › PostgreSQL DBA › Partitioning: Declarative vs. Inheritance-based 📊 Postgres Database Administration – Partitioning: Declarative vs. Inheritance-based 20 questions · 15 min timer · Explanations included · Free 1. In PostgreSQL, what is a potential drawback of using too many partitions? Increased complexity in query planning. Decreased performance due to excessive partition pruning. Increased storage requirements for partition metadata. Limited scalability due to partition constraints. None Show Hint Using too many partitions can increase complexity in query planning, as the planner has to consider more partitions, potentially impacting performance. 2. Which of the following is a limitation of using declarative partitioning in PostgreSQL? Lack of support for partition pruning. Inability to use custom partitioning strategies. Inability to manage partitions automatically. Limited support for complex partition keys. None Show Hint Declarative partitioning in PostgreSQL does not support custom partitioning strategies, as it relies on predefined methods like range, list, and hash partitioning. 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
