News for hackers. Stuff that matters.
Re:PostgreSQL 10 Released by halayli on Thursday October 05, 2017 @01:05PM (#15410717)
PostgreSQL uses shared memory, it doesn't copy the hash table.
Re:PostgreSQL 10 Released by anarazel on Thursday October 05, 2017 @01:52PM (#15411058)
In the specific case of hashjoins, it does build them independently right now. There's a patch to rectify that though, by putting the hashtable also into shared memory. The coordination necessary to make multi phase batch joins and other such funny bits work, unfortunately made it infeasible to get into 10.
Re:PostgreSQL 10 Released by halayli on Thursday October 05, 2017 @04:42PM (#15412436)
I stand corrected, it definitely reconstructs the hash table in each process.
Re:PostgreSQL 10 Released by anarazel on Thursday October 05, 2017 @05:16PM (#15412654)
FWIW, here's the patchset to fix that: https://commitfest.postgresql.org/15/871/
Re:PostgreSQL 10 Released by halayli on Thursday October 05, 2017 @07:35PM (#15413390)
Thanks! I remember reading this thread a while back and I thought it made it in.