The startup cost is pretty expensive. This seems to be common issue using
partition wise joins.
I attached a simplified reproducer. Thanks for having a look!
Regards
Arne
From: Tom Lane
Sent: Friday, February 26, 2021 4:00:18 AM
To: Arne Roland
Cc: pgsql
Hello,
I attached one example of a partitioned table with multi column partition key.
I also attached the output.
Disabling the hash_join is not really necessary, it just shows the more drastic
result in the case of low work_mem.
Comparing the first and the second query I was surprised to se
It's definitely a quite a relatively complex pattern. The query I set you last
time was minimal with respect to predicates (so removing any single one of the
predicates converted that one into a working query).
> Huh. Ok well that's a lot more frequent that I thought. Is it always the
> same q
Hello,
does anybody have any idea what goes wrong here? Is there some additional
information that could be helpful?
All the best
Arne Roland
