News for hackers. Stuff that matters.

A comment on PostgreSQL 15. Parent comment

Re:PostgreSQL 15 by tpetry on Thursday October 13, 2022 @11:06AM (#33192048)
Most parallel operations in PG are implemented by simple merge the dataset, work independently and merge the results. I expect the new distinct to behave the same and not work on a shared data structure.
[ Parent | on HN ]
Re:PostgreSQL 15 by jeltz on Thursday October 13, 2022 @11:16AM (#33192192)
You are correct: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit...
[ Parent | on HN ]
Re:PostgreSQL 15 by chrstr on Thursday October 13, 2022 @12:04PM (#33192873)
Thanks! May be helpful to include this in the documentation, since I guess it will then often depend on the numDistinctRows estimate [1] if the parallel plan is used.

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f...

[ Parent | on HN ]