On 02/06/2018 03:40 PM, Tomas Vondra wrote: > > > I plan to go through the patch and this thread over the couple of > days, and summarize what the current status is (or my understanding > of it). That is (a) what are the missing pieces, (b) why are they > missing, (c) how we plan to address them in the future and (d) > opinions on these issues expressed by others on this thread. >
So, I've promised a summary of the patch status about three weeks ago. I've been postponing that as Pavan was moving the patch forward pretty quickly, and now there's not much to summarize ... which is a good thing I guess. If my understanding is correct, the MERGE now supports both partitioning and RLS, and subselects should also work on various places (which is somewhat consistent with my impression claims about SQL standard prohibiting them were not entirely accurate). Which leaves us with figuring out the right concurrency behavior, and that discussion seems to be in progress. So at this point I'm not aware of any other missing features in the patch, and a more detailed summary is not really needed. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
