[prev in list] [next in list] [prev in thread] [next in thread] List: postgresql-general Subject: Re: [HACKERS] foreign key locks From: Alvaro Herrera <alvherre () commandprompt ! com> Date: 2012-06-29 23:26:22 Message-ID: 1341012276-sup-2829 () alvh ! no-ip ! org [Download RAW message or body] Excerpts from Alvaro Herrera's message of vie jun 29 19:17:02 -0400 2012: > Excerpts from Kevin Grittner's message of mié jun 27 08:40:58 -0400 2012: > > Alvaro Herrera wrote: > > > > > here's fklocks v14, which also merges to new master as there were > > > several other conflicts. It passes make installcheck-world now. > > > > Recent commits broke it again, so here's a rebased v15. (No changes > > other than attempting to merge your work with the pg_controldata and > > pg_resetxlog changes and wrapping that FIXME in a comment.) > > Here's v16, merged to latest stuff, Really attached now. BTW you can get this on github: https://github.com/alvherre/postgres/tree/fklocks -- Ãlvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support ["fklocks-16.patch.gz" (fklocks-16.patch.gz)] ����O fklocks-16.patch �<kw�Ȓ��Wt��"����%6Nر���s�,GH h"$F~���}��[O$Μ=�ݜ��������]B7&V�L ��5Ͷ<��&��G�f/�������t4�ƛB� K��59��x�Z��ɡ~��zko/_�T6��We���'�4����?����{�i�e��f�5�lb;ܘZ�S�&gu:i�m!�N;�a���{L��O;�S�;\Û�(��d�^ő������ �zg~�|�G.G�`���6LCs�t���o�IZY���[���nO��w/;��z�E�m��wd����f��ܙ�4u��f���4q^�S \ nX�k^m���diinU�S��f��i�I��5��q��fላm�k�I�J��G8`dx|��>�ή/O������0(�Y.��@?�p�09|ѹSbW0��0��x���K�rw��K�~�� C������S�[Γ���fnXEA�*��� ǫ��ʶ���]Ed �MQ���j�]=��j�@�T���[Uc�jQ����6,���/�ʱ7�<��p�aʄBxÚ�s��քA��:-S�-�lSW=5.� \ Rbt�q��@bvu5Cb��$D6ev�^n1>Qb��!`FT<1�.��Kf�4�Pfc�6�i��6��7�cl�妶7�7t��D5]�&� \ aguX�7�)��B�@̗�gdt�۰�x�(�&�|���bȥ�^���;,7�Q����vc�ma+�=�&�s�K��B�f�A�Y�|s���&Ɍ +b�W/'�Uf�s��.z5 \ �@ �q�%p��y�j^W](�؋w������vKd��).�l��j=� -�#؏fr&�ނW%0~�,&����a.��Yd��� \ �4�-<��U(����h�[(�Dz��}kXS�zj]Y�Q_zb<Urq�\U~���������J�K��p����zo̗sF�PM�� \ �J0�!#Y#ɜ���o �|=}$7��1y��E��g�:�� Ϝ�3R=�y`�1���?��B{��7���/|��X�D��.$3x"��HX~� \ E8W�� �Zђ|�[��#�6@;6m����T�)�<߁�'�]��-��F�'�`�|X����p�;W��d�13�k��z�Sl���.b�Еm�E̡�ı"��0 >f��0�'�}j�3�`�$L� �A�2lmd~� L�2.�@��jU�Z ��Ig��KbP(h��f��d �m��i.��F��O���⭐RԼR{�W e9�&�8i�l1w9� ��"m��&�=' @�9u�*;'l�`��>0�m���U�M�S=Cc8�|q�41�����d�S� V��6�r@L�X� \ ���E����U{��� ���Dpdv��N���h�r���]d�`���-���n�@�G_BlCq�.�~l��8�W��k-`�c ��v���>�E��&�$ziϪ�)Ν� g���X� Nѻ���ڙ{�I��K%̻V]�FI0���P^� �/r��!7clY�Hd���U>D����$�UĐ%��s<��g92�#�[QJIL�N@~Q�""�Ee�������5 ]$̀�smaִ�K+��������y��=���c�s�>u/w�d��1v.��7� \ c�:�?������F! ]&r� r6ew�QnP��it֓�@Q�'�P���p��-�5t��XBCZ��ŰpD6pbەG��Qӫd����շ�m` \ 'W�u�7�O�'= �|�Q-\�a[B9{�t2�l"&r�I��@�=ų���sw�)m�m���l~����7�T�.� G؝@��h.�%�}��e�k�P�u�Q�˾O�].� ���v�!fߵ -c���)E�-q!U��P�h�D{-��u���M�z�f�[<r���\ǭ�H)����F�d w��y|���xUg�\gN,P-�-=� \ 6:N���4�Q3˫To�Ď߱���a�}2�����������=���C��J��g�ACLIi��{Y�)z�|-������<��r�("�&�JN�!r�p��CY��$���l��`s��rAb���.�q���`a�:�������fU1�2����f�R��� _d@A��*v��c�.Ye�e��R����"u� �g�[<��w���� � O�v�AKp"���s���bwcR� I���@�������T��hW<�1���T�L��c�r�7�� �5���3��>��ea��b�po�X \ ��G�)��D-�cp�CT��4i�^V�F��۲�7@�ߩ&�5m����uλ�cI�0��Rx�1�H�gk�L�w�{��A��<��F��M�>�(U��K��.�"�A��X�Jy�����3����_ \ 6,�~���7.�W��~{�q�>}]��h�껍H�4@��A��G����B�Z��Or�s��z>1��0_�Q���+Eu.|'� � \ t]M��ɥ� >�Xs�$������0<6�m�l��{��f��¹�;���PF��(::�6�3�h�<̼�r�;T�P�q� \ �?�+et���=<W�~X�k�f����|�B�y%�������yg46��w,�g���9��ڪ6�~�fعt{�,_9��5�T�4��k[ZU�f_��J����X�O�HC S5&(V׃����� � �>�]�u?-r'�t��e� \ ��Y�y��$s[����C�/�5�N]��m�Z�f�f��M���c" F#�Y�����Tea�`? \ q5ǀ8�5բ�]Y x�9�����~"Y�+_�6��5�5�dgd+���{��/- \ ��>�-J�N�+�WD:��]tmk��@��h�,u�@����a?�G Ɇ��r.,� ��� ��& \ $n5�F@ �g �G��ŏ�_0nH�K�\�b�9��1v/����`z܁� \ \��]p�z^�w����t��3�Z���i@��}��)���u;y��u�C����=�7�i6d \ �ez���G���^�*�.ۨ�!GU��Y���T6P��Fj�kX�h�]V�i ��l��M� \ 4BOφ0�P��'pe�Je]�l�+�m���*� \ ����ҿ�����@�{p4�{��Yu0�;�g��������'�`S!�b��s�Y��=�`�ʨ��±���+��#�]ೱ���@b ����rn��+<� \ ��SH���X�[�\۳��g�\}��~���r��vå��5WG�F�r�+�$���Jǂ�c�Ou|��d~ήqP>8�o��7�O�� M�" \ ���L����ۨ*t�=<�,�2;��;���pJ�^08^�B'[���Q����s�t�1/�:C�R3&n�V.�+���&��� ���� \ ���O6�ͦɂ��,ܽ^��eU�9��a4�ʱ�4�Sf���:��y��Uˋ9:���*e�txC�H�����@��}�[)�E K�Z�9�AG��G�{����d��J��D���-��L�� ��1�aU�7Z~*�T�KU��k�� ��<3tY��� �8�~��B}x�%�,��'��oU��i(��yW=�t�g��݂�[!�r�U�mqёc/�;^�������}3�^��>�� Ft�Ŗ��HXL�����P,�?QpVe�X4�ثW�HXQ+h�k���[�*�蔭�b�|� ������+K��mCQ��8KL؈��E�=�"XX{�S뜅�ܜ$j��)��[OO� �"S�c�E���HI�y� pA�rQ,�� ���&�I��=�������إ� >��_/THD�A���r���h�ķ9G ^�;�� 毤�?� �l��p�k&���]�>�^�����?cO��;��s��!�Z��`�$�� ~o����[>��x��o� \ �H�#���w"[Wf/���.��w4�"� �@�^�;Q�P��FQ{. �Y��.�.R��3W���`�.ǟ�(@ \ ���o0��=-ҫH ,��w����$�bT���0unN�I�ُ��aq����.J%߁<a�) �]��Q*�|��� KU0�^�(�$q;anB�`�q+ �독7i� ��0�ZS^��<%c�"��6�Q ��SĮH�����f���La���Xp�x�����BF'!��`� A)|�vn7l���dަ�$���do��H_��(�� \ ����'�Cd�qf���[D�ɉ�zţ�k]9�ԁܶ�3����@V��#�T��`�� �9Ч4�}TH�����E�^L�ʁ \ ��Tْ���y-`��(J��G��K��'�C%ǃU�.Z��z�B<o!���^z��Y�%˂$d��zOo�)�,�\����X1�GX�@X�l�ʉ���7� \ ��ס�Ϙ/�2ݻ����7Oٔ��C��* �=%0zB�&B!�z�<~mHY����SB�k�Yվ��<�-����F�F�� �wź*�=m�z>��p�� \ D�,�wA�t �b�&?)���Q<q#X�iۺ������f!y0�>+�I�ٲ�6����-�fz����Dщxc���8�?p���A����Q����Z�5�u͞� +8XM�p�xJE����������IE�8(I\���� �#�1��A�� �~�X��7����W�ecn-�I�/x:��q?���'4 Yi�SG$M�S�G)pgF����:��ڙ'��)�$��M2��[�״�K�cYI��fi \ �j��L}5�E{%��Gy������%)�|9�^��C�yp$K��Ոk�xMP����|*����UK��>�k&:�;1�j�����d�%�r� \ V��Z��r1�� �"m�|g�xHo����d}0m��u�`,U�ǫ��:F���㡪�{��T��&�b�?���e�fX��:Ѽ�2�)�!��S�n�� R�,���h�U��D�?<з��6����e/��Ο�����VKK��~�wlX|�W���r3��Fc�� ����|��F�6�5��������5����F��C���}Q��>�#n;�8?�o�nk5ׁ�s3�d|�<����'js�Z�?8:��&�Mx��� \ ��r|�\�?��S�Zp�ɞ�w����68Ǥ�X�_���ɫ0@�&`䐷5h�{%���ԏ�����hs�31!�q�ok�5�4<�汸�x[;�r~�{6H��l��/�\h��BC4�z+���˝��BH�\kbk�/��[�� ��e�ק�ȫpN��־_���l9�M� g��\�yf���i�)��$��0W��$��D�)���/�]M�G�� \ T�*���ƛ�@��p��q�A{5�$�P�\'�wl!�xa9��*C��W�,("�&��b��l[��I��&T[����5�!����� \ -N"H��I����gTD��A��M�N��a�z�����q�>�����Bu�_�{U��_�pI����gv���u�U=,�,p.�� \ wv6�ס���I����O�>�k��3<��;��C��(~~�t���G�I5��HR�>