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. Which of the following is a best practice when designing a partitioning strategy in PostgreSQL? Always use inheritance-based partitioning for better flexibility. Use a single partition key for all tables to maintain consistency. Consider the query workload to choose the appropriate partitioning method. Avoid using partitioning for tables with less than 1 million rows. None 1 out of 20 2. 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 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!
