The Truth about Partitions
Beena has about 7 years experience in PostgreSQL and was involved in developing features like multiple synchronous replication, making wal segment size configurable at initdb time, addition of default partition and runtime partition pruning.
A native partitioning system was added in PostgreSQL 10 and it has since evolved considerably. In PostgreSQL 13 the existing Postgres benchmarking tool pgbench was extended to allow testing for range and hash partitions.
Choosing a good partition strategy is not a child's play. Partition done wrong can lead to massive performance deterioration.
This talk will summarise all the features and key improvements across versions including the new pgbench partition options. It will also attempt to reveal when using partition a good idea and when they can cause the performance to nose-dive with the help of benchmarking results using partitions in different settings.
- 2020 February 28 - 14:15
- 40 min
- Grand Victoria 1
- PGConf India, 2020
- Database Administration
- Looking beyond B-Tree Index for performance optimizations
- Start Time:
- 2020 February 28 14:15
- Grand Victoria 2