Re: [COMMITTERS] pgsql: Add hash partitioning.

2017-11-13 Thread amul sul
On Mon, Nov 13, 2017 at 12:41 PM, amul sul wrote: > On Sun, Nov 12, 2017 at 3:01 AM, Andreas Seltenreich > wrote: >> Robert Haas writes: >> >>> Add hash partitioning. >> >> sqlsmith triggers coredumps calling satisfies_hash_partition(). >> ISTM this function is lacking argument validation. Exam

Re: [COMMITTERS] pgsql: Add hash partitioning.

2017-11-12 Thread amul sul
On Sun, Nov 12, 2017 at 3:01 AM, Andreas Seltenreich wrote: > Robert Haas writes: > >> Add hash partitioning. > > sqlsmith triggers coredumps calling satisfies_hash_partition(). > ISTM this function is lacking argument validation. Example: > Thanks for the bug report. Please find attached patch

Re: [COMMITTERS] pgsql: Add hash partitioning.

2017-11-11 Thread Andreas Seltenreich
Robert Haas writes: > Add hash partitioning. sqlsmith triggers coredumps calling satisfies_hash_partition(). ISTM this function is lacking argument validation. Example: , | PostgreSQL stand-alone backend 11devel | backend> select satisfies_hash_partition('pg_class'::regclass,null,null,null)

[COMMITTERS] pgsql: Add hash partitioning.

2017-11-09 Thread Robert Haas
Add hash partitioning. Hash partitioning is useful when you want to partition a growing data set evenly. This can be useful to keep table sizes reasonable, which makes maintenance operations such as VACUUM faster, or to enable partition-wise join. At present, we still depend on constraint exclus