Re: BUG #19634: Hash partition with large MODULUS causes "invalid memory alloc request size"

Hi,

On 2026-08-21 14:04:09 +0200, Pierre Forstmann wrote:
> I propose following patch that adds the check to new_partition_bound
> routine:
>
> postgres=# CREATE TABLE t (id int) PARTITION BY HASH (id);
> CREATE TABLE
> postgres=# CREATE TABLE t_p0 PARTITION OF t FOR VALUES WITH (MODULUS
> 268435457,
> REMAINDER 0);
> ERROR:  hash partitions bounds are too large
> DETAIL:  Creating hash partitions for modulus 268435457 would require too
> much memory.
> HINT:  Reduce the number of partitions.
> postgres=#

I am not sure it's worth doing *anything* here. There's at most a slightly
suboptimal error message here. There are many many ways to get those. Nobody
sane would create a setup like this unless they're explicitly trying to find
unexpected errors or such.

Greetings,

Andres Freund