Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fDAmw-0007j2-TK for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 30 Apr 2018 15:32:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fDAmv-0002Gm-RI for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 30 Apr 2018 15:32:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fDAmv-0002Gc-GC for pgsql-pkg-debian@lists.postgresql.org; Mon, 30 Apr 2018 15:32:25 +0000 Received: from mail-wr0-x231.google.com ([2a00:1450:400c:c0c::231]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fDAmr-00019l-BD for pgsql-pkg-debian@postgresql.org; Mon, 30 Apr 2018 15:32:24 +0000 Received: by mail-wr0-x231.google.com with SMTP id i14-v6so5278329wre.2 for ; Mon, 30 Apr 2018 08:32:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:openpgp:autocrypt:message-id:date:user-agent :mime-version; bh=PZNozSElLlFvw/PDu2Lxk2pkUAZ85KbZmQ06/6h+uiI=; b=bHPLSfBAYGlQ0u6OinZQBdSbND17sNYMCrjoHN2VV6imH2FKic+qlm+ek/C2hQemwn LFiq4LewHOaVsh1ZU3JzKj+wvOmWuFFThMt7I8DDIY/3BS7oMr3HPi8meGtwCDjWPBa6 eR4LQN40e3ZHGWG2ZZdWPCbzOXsJ5pLDJiqpRhVF1SaN4OPti/RAkJecnYJhxHjHBsRh ch3bUyHPiexG/uGgxDBRV0gSBnorcA9HNobjNyMY08WYMYIDvKaQESdZzBcAEugAaiV5 6fU41bwjWfSQ+slmLYWaqUSf/RH7CWwfE5cuI5QPYR1/opYMn+K2bJft1+5XExJ/8I75 H7LA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:openpgp:autocrypt:message-id :date:user-agent:mime-version; bh=PZNozSElLlFvw/PDu2Lxk2pkUAZ85KbZmQ06/6h+uiI=; b=j+jgRx5RHVSN40l9Doh+qEQ+yGIJE5BY0Ex0mTzy+TL++SFjd0nMsAsLtbUcsBnK4q Jd+Mchzk+lwFBLrEv1G63IAsSmsQuB3PWxIg/uyzhDejgfak4j+LLB/0Cdhq8gaCSEmD /nwESo8DOvRuj3CGikQEMQqEzBLgXzRBhoNp8QLg9+Q37JKVl7dLnKFGWhuCQFBGHtzc mbzAFLcwy8NBjFDxqV/vN5W6uwAIj6G9dUrXAJ4a8OnP7boQxSjgUWYYm1RAF5/Bhctp 4DnKoA3o0buIxt8ewKZ7iwC7SQ4plzqINT8ItBs5U90vBIpz8DxWRcbEQuqRlqIJgLRj zIBg== X-Gm-Message-State: ALQs6tB9Mbyr0lxSU8PdaoPp69vpwGtIo6qiZwS60E+sB1hHRMgEc8Fx BVo/UH/YsGUb5smTKE6pFk69UQQC X-Google-Smtp-Source: AB8JxZrVv+TIap+7Qwr7u8rQVKn2Z55B5e44JHg2EaZJDeQGO49U2l9z1m0J9Qd7V6SU15U9TUaTuQ== X-Received: by 2002:adf:a075:: with SMTP id l50-v6mr10004366wrl.227.1525102339167; Mon, 30 Apr 2018 08:32:19 -0700 (PDT) Received: from [10.1.105.165] ([195.25.236.203]) by smtp.gmail.com with ESMTPSA id 12sm11297040wmn.27.2018.04.30.08.32.17 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 30 Apr 2018 08:32:18 -0700 (PDT) To: pgsql-pkg-debian@postgresql.org From: Marc Cousin Subject: libuuid performance impact Openpgp: preference=signencrypt Autocrypt: addr=cousinmarc@gmail.com; keydata= xsBNBFlwwSIBCACtPV+Ciu0/ZrcUzC+KScvsGgfg5pYz2pKoZr8o3UIko2kRPiycsw2or98k 6YnfLmGm/l46712vWclyJhlZhO/LTHQlMOqK51JfxQDcJPqaZHFDuXz+5IRn/Jq4GLRU+vbM ZMmii3Nvh2FgHU65smSSWnmlG261U4uDUklEjyq9c7KIayyfV6mo8Yx1JplDql8dYGVqFy2x MHIVrXGz+4HSl+ttXWIp4hfb+SFBjhVsWjP6Gkb4tWQp5AmP5zn/U002AxbK7d4aEUDIYh/M hioYzI9AyoEqVFRuQoqLUgZC2tmAoyemtG2xznHRoNfRLkWUP1w4LxdIF6RHVm/LCg+VABEB AAHNIk1hcmMgQ291c2luIDxjb3VzaW5tYXJjQGdtYWlsLmNvbT7CwI4EEwEIADgWIQStEkWi pDVaYcLm2jT298ZWi8CQnwUCWXDBIgIbAwULCQgHAgYVCAkKCwIEFgIDAQIeAQIXgAAKCRD2 98ZWi8CQn54gB/91jBW7cwU+yaZ64z32PlyKZMn/3JFV1A1R6hehlTaiI/w0/szKpre9n5BR pQSzOUUGlquZ1flMozyR9vud/wuNXU3FE9YI8cmHOJgAYUEtQaiSNLEMfdl55SADYkLKNJot 0jDf8NFiSfu3Qaw5pRlwi5+LFfm48PpQtCyLsxjntrYcuRB0PBLaMbCwbMfhyfBFTI3/nN4b K9hIHmK9Vecg7l55NAz99dIyzcHLk5sSE/MPXd8wlV4kACWH1+CuItioO3sUcAlLvCB0QzcE zdpc9wJl1rE7cTYG+/4EGKJ0AZyIPWN9ApUWrRAsY8YByHRv7JGgj8U8IC65pCkCQG1qzsBN BFlwwSIBCADBVrMqQ+BHb6YVuTiSigcleaMH1A2Sb7aF5UZXdsrUI0EmFEWeUABD6g+MC0Pg 78Xg0L3SdmW7nAz+l1AoX6HYP0jgxVlRCOXcTfDdVBg8wsgYyjv8Ar4JkOvOWwDwhtcwHQfc xeCAUghtI1tvgaw297gx9KFu6czwBjwLIBMpHUPcYze4HryMct1z/NMUwduRyoT1hlZq8dNe sG8AON+9It1lXHm3CI55iEIeTDlkPJBhl4ngxPeWSNoe1XnW1qtyrQJ9ICuddP4Ty9JEuTQ8 LA6ljiqDF//5/05gw38IelGMevuNOA2I6l228qtWmgYaB7tfoLKJdUCGPAr4u3etABEBAAHC wHYEGAEIACAWIQStEkWipDVaYcLm2jT298ZWi8CQnwUCWXDBIgIbDAAKCRD298ZWi8CQn7Fv B/9t4EuKxWEzjdLciVtoL+Pm4KcwRQbqiUg30J1REZnuEXHvdfAqxDcC5QWiNzu9occnbcxa cFoUtA83dseDlAT1uL1eUdv8njY8GE12IO9KLdH8JfzR4sQGimEJ3YC+yY18aHi7v9M2EY3f uArH0LNik82kjF+8U5ndsSlkJ/WD8fR82SQkZuNYoeCIfa+p/VKn7f8Ommz27WtMa6IfCFj1 O8PNaDkr3YUVSpWimSJPmNXm+xbsyDWSbP6M6M6IVt9sOcdl+ohQDrK+5mfYjRACPrTGOe1z 5CB21gJ8KsVxvolvJIgsIm8qytOdEyOdY6wDW2rb4ZZuHWk7bstcN08F Message-ID: <4f125945-e979-1f9e-a39b-a4bf5a4eca6b@gmail.com> Date: Mon, 30 Apr 2018 17:32:17 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.7.0 MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="FBnaeCPwWmkQcWCGNsBXpX7Yf3tuEfefY" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --FBnaeCPwWmkQcWCGNsBXpX7Yf3tuEfefY Content-Type: multipart/mixed; boundary="MqhGfMjbLgkQwDnqdEv87Kk4HdBtdp4sa"; protected-headers="v1" From: Marc Cousin To: pgsql-pkg-debian@postgresql.org Message-ID: <4f125945-e979-1f9e-a39b-a4bf5a4eca6b@gmail.com> Subject: libuuid performance impact --MqhGfMjbLgkQwDnqdEv87Kk4HdBtdp4sa Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable Hi I've been investigating a performance "problem" with uuid generation https://jasonaowen.net/blog/2017/Apr/13/benchmarking-uuids-v2/, which I couldn't reproduce on my computer while it occurred on my servers. After a few tests, it seems to come from uuid-ossp being replaced with libuuid=E2=80=A6 when linking postgresql with uuid-ossp I get the exact s= ame performance between uuid_generate_v4 and gen_random_uuid. When linking with libuuid, I get the same results as those displayed in the linked webpage (I can provide numbers). Is this an expected difference ? Please tell me what I can provide if required. Regards Marc --MqhGfMjbLgkQwDnqdEv87Kk4HdBtdp4sa-- --FBnaeCPwWmkQcWCGNsBXpX7Yf3tuEfefY Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEErRJFoqQ1WmHC5to09vfGVovAkJ8FAlrnNwEACgkQ9vfGVovA kJ/s5wf/bK3OKqrSnKfYMr6XDYTxfwDj0imolbI+3YivzgBOLMSrZpde9zKmqjpG qrPw4694F/I8ieshKA1P5+eRMIgJETIW/WNbyD+hfOpMy3Yv5xUy2fUoZcGTALUe k0ePZ6l5rIOWvfDtkoqregMyypiEO53ThPESYY6sDCC0LrPMzGYjHnlFJYlJAlhw hfff2b6oXBRx3J9lS1h8WDoyfLMk90XuxBGPagmIEFXW+0+sFbcHig4HBrqAe4B+ I9M41u/41j6WQvqFcORtZd7ePjloLoMbskmvnwssnI6ECLS/nIK5xqdhb1NUcSBo XwLZugrmTxSbioQpOimFMquzA7cPYQ== =8oUX -----END PGP SIGNATURE----- --FBnaeCPwWmkQcWCGNsBXpX7Yf3tuEfefY--