You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
<
8000
script type="application/json" data-target="react-app.embeddedData">{"payload":{"commit":{"oid":"f77ff083350eb5a2625a4dbfca61d15b66c4918b","url":"/postgres/postgres/commit/f77ff083350eb5a2625a4dbfca61d15b66c4918b","authoredDate":"2022-07-20T15:44:44.000+03:00","committedDate":"2022-07-20T15:49:37.000+03:00","shortMessage":null,"shortMessageMarkdown":"\u003cdiv\u003eDocument the ability to specify TableAM for pgbench\u003c/div\u003e","shortMessageMarkdownLink":null,"bodyMessageHtml":"Upcoming custom Table Access Methods (TableAM) need benchmarking. Despite\npgbench doesn't have an explicit option for TableAM specification, one can\nspecify it using PGOPTION environmental variable. The present commit documents\nthis way to specify TableAM for pgbench.\n\nDiscussion: \u003ca href=\"https://postgr.es/m/CAC77N6ih%3DLbhZQXV76grEsaVQkBL464Y2Foqq9o%3Df4UBfEOfEQ%40mail.gmail.com\" rel=\"nofollow\"\u003ehttps://postgr.es/m/CAC77N6ih%3DLbhZQXV76grEsaVQkBL464Y2Foqq9o%3Df4UBfEOfEQ%40mail.gmail.com\u003c/a\u003e\nAuthor: Michel Pelletier, Alexander Korotkov\nReviewed-by: Justin Pryzby, Mason Sharp, Michael Paquier","authors":[{"login":"akorotkov","displayName":"Alexander Korotkov","avatarUrl":"https://avatars.githubusercontent.com/u/5437829?v=4","path":"/akorotkov","isGitHub":false}],"committerAttribution":false,"committer":{"login":"akorotkov","displayName":"Alexander Korotkov","avatarUrl":"https://avatars.githubusercontent.com/u/5437829?v=4","path":"/akorotkov","isGitHub":false},"parents":["bcedd8f5fce0b69970cf0cee7bca560833d05869"],"globalRelayId":"C_kwDOAA4m0toAKGY3N2ZmMDgzMzUwZWI1YTI2MjVhNGRiZmNhNjFkMTViNjZjNDkxOGI","sha1":"bcedd8f5fce0b69970cf0cee7bca560833d05869","sha2":"f77ff083350eb5a2625a4dbfca61d15b66c4918b"},"currentUser":null,"repo":{"id":927442,"defaultBranch":"master","name":"postgres","ownerLogin":"postgres","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2010-09-21T11:35:45.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/177543?v=4","public":true,"private":false,"isOrgOwned":true},"diffEntryData":[{"diffLines":[{"stylingDirective":null,"type":"HUNK","blobLineNumber":316,"text":"@@ -317,7 +317,7 @@ UPDATE pg_settings SET setting = reset_val WHERE name = 'configuration_parameter","html":"@@ -317,7 +317,7 @@ UPDATE pg_settings SET setting = reset_val WHERE name = \u0026#39;configuration_parameter","displayNoNewLineWarning":false,"position":0,"left":316,"right":316},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":317,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":1,"left":317,"right":317},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":318,"text":" \u003c/sect2\u003e","html":" \u0026lt;/sect2\u0026gt;","displayNoNewLineWarning":false,"position":2,"left":318,"right":318},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":319,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":3,"left":319,"right":319},{"stylingDirective":null,"type":"DELETION","blobLineNumber":320,"text":"- \u003csect2\u003e","html":"- \u0026lt;sect2\u0026gt;","displayNoNewLineWarning":false,"position":4,"left":320,"right":319},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":320,"text":"+ \u003csect2 id=\"config-setting-shell\"\u003e","html":"+ \u0026lt;sect2\u003cspan class=\"x x-first x-last\"\u003e id=\u0026quot;config-setting-shell\u0026quot;\u003c/span\u003e\u0026gt;","displayNoNewLineWarning":false,"position":5,"left":320,"right":320},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":321,"text":" \u003ctitle\u003eParameter Interaction via the Shell\u003c/title\u003e","html":" \u0026lt;title\u0026gt;Parameter Interaction via the Shell\u0026lt;/title\u0026gt;","displayNoNewLineWarning":false,"position":6,"left":321,"right":321},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":322,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":7,"left":322,"right":322},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":323,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":8,"left":323,"right":323}],"diffNumber":0,"diffSize":"0 Bytes","isBinary":false,"isTooBig":false,"collapsed":false,"isSubmodule":false,"lineCount":11598,"linesChanged":2,"newTreeEntry":{"lineCount":11598,"path":"doc/src/sgml/config.sgml","mode":100644,"isGenerated":false},"oldTreeEntry":{"lineCount":0,"path":"doc/src/sgml/config.sgml","mode":100644},"linesAdded":1,"linesDeleted":1,"path":"doc/src/sgml/config.sgml","pathDigest":"0553fde8fa0de14527cb5c14b02adb28bdedf3e458f7347b51fb11e1dade2fa7","status":"MODIFIED","truncatedReason":null,"oldOid":"bcedd8f5fce0b69970cf0cee7bca560833d05869","newOid":"f77ff083350eb5a2625a4dbfca61d15b66c4918b","copilotChatReference":null,"deletedSha":"bcedd8f5fce0b69970cf0cee7bca560833d05869","canToggleRichDiff":false,"defaultToRichDiff":false,"proseDifffHtml":null,"renderInfo":null,"dependencyDiffPath":null,"submodule":null},{"diffLines":[{"stylingDirective":null,"type":"HUNK","blobLineNumber":2886,"text":"@@ -2887,6 +2887,22 @@ statement latencies in milliseconds, failures and retries:","html":"@@ -2887,6 +2887,22 @@ statement latencies in milliseconds, failures and retries:","displayNoNewLineWarning":false,"position":0,"left":2886,"right":2886},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":2887,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":1,"left":2887,"right":2887},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":2888,"text":" \u003c/refsect2\u003e","html":" \u0026lt;/refsect2\u0026gt;","displayNoNewLineWarning":false,"position":2,"left":2888,"right":2888},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":2889,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":3,"left":2889,"right":2889},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2890,"text":"+ \u003crefsect2\u003e","html":"+ \u0026lt;refsect2\u0026gt;","displayNoNewLineWarning":false,"position":4,"left":2889,"right":2890},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2891,"text":"+ \u003ctitle\u003eTable Access Methods\u003c/title\u003e","html":"+ \u0026lt;title\u0026gt;Table Access Methods\u0026lt;/title\u0026gt;","displayNoNewLineWarning":false,"position":5,"left":2889,"right":2891},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2892,"text":"+","html":"+","displayNoNewLineWarning":false,"position":6,"left":2889,"right":2892},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2893,"text":"+ \u003cpara\u003e","html":"+ \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":7,"left":2889,"right":2893},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2894,"text":"+ You may specify the \u003clink linkend=\"tableam\"\u003eTable Access Method\u003c/link\u003e","html":"+ You may specify the \u0026lt;link linkend=\u0026quot;tableam\u0026quot;\u0026gt;Table Access Method\u0026lt;/link\u0026gt;","displayNoNewLineWarning":false,"position":8,"left":2889,"right":2894},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2895,"text":"+ for the pgbench tables. The environment variable \u003cenvar\u003ePGOPTIONS\u003c/envar\u003e","html":"+ for the pgbench tables. The environment variable \u0026lt;envar\u0026gt;PGOPTIONS\u0026lt;/envar\u0026gt;","displayNoNewLineWarning":false,"position":9,"left":2889,"right":2895},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2896,"text":"+ specifies database configuration options that are passed to PostgreSQL via","html":"+ specifies database configuration options that are passed to PostgreSQL via","displayNoNewLineWarning":false,"position":10,"left":2889,"right":2896},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2897,"text":"+ the command line (See \u003cxref linkend=\"config-setting-shell\"/\u003e).","html":"+ the command line (See \u0026lt;xref linkend=\u0026quot;config-setting-shell\u0026quot;/\u0026gt;).","displayNoNewLineWarning":false,"position":11,"left":2889,"right":2897},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2898,"text":"+ For example, a hypothetical default Table Access Method for the tables that","html":"+ For example, a hypothetical default Table Access Method for the tables that","displayNoNewLineWarning":false,"position":12,"left":2889,"right":2898},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2899,"text":"+ pgbench creates called \u003cliteral\u003ewuzza\u003c/literal\u003e can be specified with:","html":"+ pgbench creates called \u0026lt;literal\u0026gt;wuzza\u0026lt;/literal\u0026gt; can be specified with:","displayNoNewLineWarning":false,"position":13,"left":2889,"right":2899},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2900,"text":"+\u003cprogramlisting\u003e","html":"+\u0026lt;programlisting\u0026gt;","displayNoNewLineWarning":false,"position":14,"left":2889,"right":2900},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2901,"text":"+PGOPTIONS='-c default_table_access_method=wuzza'","html":"+PGOPTIONS=\u0026#39;-c default_table_access_method=wuzza\u0026#39;","displayNoNewLineWarning":false,"position":15,"left":2889,"right":2901},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2902,"text":"+\u003c/programlisting\u003e","html":"+\u0026lt;/programlisting\u0026gt;","displayNoNewLineWarning":false,"position":16,"left":2889,"right":2902},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2903,"text":"+ \u003c/para\u003e","html":"+ \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":17,"left":2889,"right":2903},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2904,"text":"+ \u003c/refsect2\u003e","html":"+ \u0026lt;/refsect2\u0026gt;","displayNoNewLineWarning":false,"position":18,"left":2889,"right":2904},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":2905,"text":"+","html":"+","displayNoNewLineWarning":false,"position":19,"left":2889,"right":2905},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":2906,"text":" \u003crefsect2\u003e","html":" \u0026lt;refsect2\u0026gt;","displayNoNewLineWarning":false,"position":20,"left":2890,"right":2906},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":2907,"text":" \u003ctitle\u003eGood Practices\u003c/title\u003e","html":" \u0026lt;title\u0026gt;Good Practices\u0026lt;/title\u0026gt;","displayNoNewLineWarning":false,"position":21,"left":2891,"right":2907},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":2908,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":22,"left":2892,"right":2908}],"diffNumber":1,"diffSize":"0 Bytes","isBinary":false,"isTooBig":false,"collapsed":false,"isSubmodule":false,"lineCount":2966,"linesChanged":16,"newTreeEntry":{"lineCount":2966,"path":"doc/src/sgml/ref/pgbench.sgml","mode":100644,"isGenerated":false},"oldTreeEntry":{"lineCount":0,"path":"doc/src/sgml/ref/pgbench.sgml","mode":100644},"linesAdded":16,"linesDeleted":0,"path":"doc/src/sgml/ref/pgbench.sgml","pathDigest":"21d9159db2dd2ff7672a25ac1cb247683d62527aaefd81c0b0a741b242e6d533","status":"MODIFIED","truncatedReason":null,"oldOid":"bcedd8f5fce0b69970cf0cee7bca560833d05869","newOid":"f77ff083350eb5a2625a4dbfca61d15b66c4918b","copilotChatReference":null,"deletedSha":"bcedd8f5fce0b69970cf0cee7bca560833d05869","canToggleRichDiff":false,"defaultToRichDiff":false,"proseDifffHtml":null,"renderInfo":null,"dependencyDiffPath":null,"submodule":null}],"splitViewPreference":"unified","ignoreWhitespace":false,"repoOwnerGlobalRelayId":"MDEyOk9yZ2FuaXphdGlvbjE3NzU0Mw==","commentsPreference":"visible","diffLineSpacingPreference":"relaxed","useMonospaceFont":false,"pasteUrlLinkAsPlainText":false,"userNotices":[],"path":"/postgres/postgres/commit/f77ff083350eb5a2625a4dbfca61d15b66c4918b","fileTreeExpanded":true,"headerInfo":{"additions":17,"deletions":1,"filesChanged":2,"filesChangedString":"2"},"moreDiffsToLoad":false,"asyncDiffLoadInfo":{"startIndex":2,"truncated":false,"byteCount":1027,"lineShownCount":32},"commentInfo":{"canComment":false,"locked":false,"canLock":false,"repoArchived":false},"csrf_tokens":{"/users/diffview?diff=split":{"post":"ZWqywZWLet6yp7HSTib5bplJx8ZgRkh8FYo-TL5gQiMZaL0_d_rG5b0JJ1GQls04SCfVU3knv1V8nfrs1-zckA"},"/users/diffview?diff=unified":{"post":"TP4Hq-YL9O60Bhb5vOCSAcCZSvz3Uyo9YpuVlZiK3_Qw_AhVBHpI1buogHpiUKZXEfdYae4y3RQLjFE18QZBRw"},"/notifications/thread":{"post":"necl3UzpsMBVyMdhdaQZ40YVOmdBaCl1ER1erZ6ZIXTDXDrBfcYK7Izk-ohkpNP8K-HYHnmw3h_CeERKQ-Gpow"}}},"title":"Document the ability to specify TableAM for pgbench · postgres/postgres@f77ff08","appPayload":{"helpUrl":"https://docs.github.com","findInDiffWorkerPath":"/assets-cdn/worker/find-in-diff-worker-2bfe39677d14.js","enabled_features":{"diff_ux_refresh_beta":false,"diff_inline_comments":true,"diff_ux_refresh_ssr_five":false,"diff_ux_refresh_ssr_ten":false,"react_diff_line_type_character_correction":true}}}
Document the ability to specify TableAM for pgbench
Upcoming custom Table Access Methods (TableAM) need benchmarking. Despite
pgbench doesn't have an explicit option for TableAM specification, one can
specify it using PGOPTION environmental variable. The present commit documents
this way to specify TableAM for pgbench.
Discussion: https://postgr.es/m/CAC77N6ih%3DLbhZQXV76grEsaVQkBL464Y2Foqq9o%3Df4UBfEOfEQ%40mail.gmail.com
Author: Michel Pelletier, Alexander Korotkov
Reviewed-by: Justin Pryzby, Mason Sharp, Michael Paquier
0 commit comments