Neues vom PostgreSQL Planet
Umair Shahid: When HASH partitioning works better than RANGE
I have always been a fan of RANGE partitioning using a date/time value in PostgreSQL. This isn't always possible, however, and I recently came across a scenario where a table had grown large enough that it had to be partitioned, and the only reasonable key to use was a UUID styled identifier.
The goal of this post is to highlight when and why hashing your data across partitions in PostgreSQL might be a better approach.
Range vs. Hash Partitioning in PostgreSQL
Range Partitioning (A Quick Recap)
Seiten
- « erste Seite
- ‹ vorherige Seite
- …
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13