Horton

Re: Problem, partition pruning for prepared statement with IS NULL clause.

Sergei Glukhov <s.glukhov@postgrespro.ru>

View thread View on postgr.es
From: Sergei Glukhov <s.glukhov@postgrespro.ru>
To: David Rowley <dgrowleyml@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2023-10-11T09:59:37Z
Lists: pgsql-hackers 

On 10/11/23 13:19, David Rowley wrote:
>
> Thanks for having a look.
>
> Unfortunately, I'd not long sent the last email and realised that the
> step_lastkeyno parameter is now unused and can just be removed from
> both get_steps_using_prefix() and get_steps_using_prefix_recurse().
> This requires some comment rewriting so I've attempted to do that too
> in the attached updated version.

Thanks, verified again and everything is fine!

Regards,
Gluh

Commits

  1. Fix runtime partition pruning for HASH partitioned tables

  2. Fix incorrect step generation in HASH partition pruning