{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/3336","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/3336/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/3336/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/3336/events","html_url":"https://github.com/cockroachdb/cockroach/pull/3336","id":120664534,"number":3336,"title":"sql: benchmark pgwire,postgres with SSL","user":{"login":"tamird","id":1535036,"avatar_url":"https://avatars.githubusercontent.com/u/1535036?v=3","gravatar_id":"","url":"https://api.github.com/users/tamird","html_url":"https://github.com/tamird","followers_url":"https://api.github.com/users/tamird/followers","following_url":"https://api.github.com/users/tamird/following{/other_user}","gists_url":"https://api.github.com/users/tamird/gists{/gist_id}","starred_url":"https://api.github.com/users/tamird/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tamird/subscriptions","organizations_url":"https://api.github.com/users/tamird/orgs","repos_url":"https://api.github.com/users/tamird/repos","events_url":"https://api.github.com/users/tamird/events{/privacy}","received_events_url":"https://api.github.com/users/tamird/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-12-06T22:21:18Z","updated_at":"2015-12-07T18:38:35Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/cockroachdb/cockroach/pulls/3336","html_url":"https://github.com/cockroachdb/cockroach/pull/3336","diff_url":"https://github.com/cockroachdb/cockroach/pull/3336.diff","patch_url":"https://github.com/cockroachdb/cockroach/pull/3336.patch"},"body":"postgres ssl config as follows:\r\n```\r\n$ psql -c 'SHOW config_file'\r\n               config_file\r\n-----------------------------------------\r\n /usr/local/var/postgres/postgresql.conf\r\n(1 row)\r\n\r\n$ cat /usr/local/var/postgres/postgresql.conf | grep ssl\r\nssl = on\t\t\t\t# (change requires restart)\r\nssl_cert_file = '/Users/tamird/src/go/src/github.com/cockroachdb/cockroach/resource/test_certs/node.server.crt'\t\t# (change requires restart)\r\nssl_key_file = '/Users/tamird/src/go/src/github.com/cockroachdb/cockroach/resource/test_certs/node.server.key'\t\t# (change requires restart)\r\nssl_ca_file = '/Users/tamird/src/go/src/github.com/cockroachdb/cockroach/resource/test_certs/ca.crt'\t\t\t# (change requires restart)\r\n```\r\n\r\n```\r\nname                   time/op\r\nBank-4                  864µs ±11%\r\nSelect1_HTTP-4          504µs ±19%\r\nSelect1_HTTPS-4         463µs ± 7%\r\nSelect1_RPC-4           118µs ±12%\r\nSelect1_RPCS-4          131µs ± 7%\r\nSelect1_Cockroach-4    89.6µs ± 7%\r\nSelect1_Postgres-4     80.7µs ± 9%\r\nSelect1_MySQL-4        72.8µs ± 9%\r\nInsert1_Cockroach-4    1.45ms ± 4%\r\nInsert1_Postgres-4      199µs ± 7%\r\nInsert10_Cockroach-4   2.03ms ± 6%\r\nInsert10_Postgres-4     248µs ±13%\r\nInsert100_Cockroach-4  6.75ms ± 4%\r\nInsert100_Postgres-4   1.60ms ± 4%\r\nScan1_Cockroach-4       542µs ± 6%\r\nScan1_Postgres-4        106µs ± 6%\r\nScan10_Cockroach-4      619µs ± 8%\r\nScan10_Postgres-4       110µs ±12%\r\nScan100_Cockroach-4    1.22ms ± 4%\r\nScan100_Postgres-4      177µs ± 5%\r\n```\n\n<!-- Reviewable:start -->\n[<img src=\"https://reviewable.io/review_button.png\" height=40 alt=\"Review on Reviewable\"/>](https://reviewable.io/reviews/cockroachdb/cockroach/3336)\n<!-- Reviewable:end -->\n"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/162617991","html_url":"https://github.com/cockroachdb/cockroach/pull/3336#issuecomment-162617991","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/3336","id":162617991,"user":{"login":"tamird","id":1535036,"avatar_url":"https://avatars.githubusercontent.com/u/1535036?v=3","gravatar_id":"","url":"https://api.github.com/users/tamird","html_url":"https://github.com/tamird","followers_url":"https://api.github.com/users/tamird/followers","following_url":"https://api.github.com/users/tamird/following{/other_user}","gists_url":"https://api.github.com/users/tamird/gists{/gist_id}","starred_url":"https://api.github.com/users/tamird/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tamird/subscriptions","organizations_url":"https://api.github.com/users/tamird/orgs","repos_url":"https://api.github.com/users/tamird/repos","events_url":"https://api.github.com/users/tamird/events{/privacy}","received_events_url":"https://api.github.com/users/tamird/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T18:38:35Z","updated_at":"2015-12-07T18:38:35Z","body":"> Did the switch to larger certs make the regular test suite any slower?\r\n\r\nDoesn't seem to be noticeable."}}