pg11 list partitions vs hash partitions

Mariel Cherkassky <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CA+t6e1k+VuviGp23hBsyTcNrZABO+KmjvE3OQg8YegqgO+bKFg@mail.gmail.com>
Hey,
I'm trying to understand when using hash partitions can be better than
using list partition when the partition column is bigint. I understand that
If my partition column  has many distinct values then If I'll use a list
partitions I might have a lot of partitions. On the other hand, with hash
partitions on that column I can combine a few partition keys to the same
partition.

I understand that maintenance on more partitions is harder but the
performance with list partition should be faster because we will have less
records in each table. Is there any reason hash partitions will be better
than list partitions in aspect of peromance ?

Thanks !
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.