When to use PARTITION BY HASH?

2020-06-02 Thread Oleksandr Shulgin
Hi! I was reading up on declarative partitioning[1] and I'm not sure what could be a possible application of Hash partitioning. Is anyone actually using it? What are typical use cases? What benefits does such a partitioning scheme provide? On its face, it seems that it can only give you a numb

Re: When to use PARTITION BY HASH?

2020-06-03 Thread Oleksandr Shulgin
On Tue, Jun 2, 2020 at 7:33 PM Justin Pryzby wrote: > > To: pgsql-gene...@lists.postgresql.org, > pgsql-performance@lists.postgresql.org > > Please don't cross post to multiple lists. > > On Tue, Jun 02, 2020 at 07:17:11PM +0200, Oleksandr Shulgin wrote: > >