Help
RSS
API
Feed
Maltego
Contact
Domain > www.dbaglobe.com
×
More information on this domain is in
AlienVault OTX
Is this malicious?
Yes
No
DNS Resolutions
Date
IP Address
2016-08-25
173.194.193.214
(
ClassC
)
2024-08-06
142.250.217.115
(
ClassC
)
Port 80
HTTP/1.1 301 Moved PermanentlyLocation: https://www.dbaglobe.com/Content-Type: text/html; charsetUTF-8Date: Tue, 06 Aug 2024 03:32:07 GMTExpires: Tue, 06 Aug 2024 03:32:07 GMTCache-Control: private, max-age0X-Content-Type-Options: nosniffX-Frame-Options: SAMEORIGINContent-Security-Policy: frame-ancestors selfX-XSS-Protection: 1; modeblockServer: GSEAccept-Ranges: noneVary: Accept-EncodingTransfer-Encoding: chunked HTML>HEAD>TITLE>Moved Permanently/TITLE>/HEAD>BODY BGCOLOR#FFFFFF TEXT#000000>!-- GSE Default Error -->H1>Moved Permanently/H1>The document has moved A HREFhttps://www.dbaglobe.com/>here/A>./BODY>/HTML>
Port 443
HTTP/1.1 200 OKContent-Type: text/html; charsetUTF-8Expires: Tue, 06 Aug 2024 03:32:07 GMTDate: Tue, 06 Aug 2024 03:32:07 GMTCache-Control: private, max-age0Last-Modified: Mon, 05 Aug 2024 23:19:21 GMTX-Content-Type-Options: nosniffX-XSS-Protection: 1; modeblockServer: GSEAccept-Ranges: noneVary: Accept-EncodingTransfer-Encoding: chunked !DOCTYPE html>html dirltr xmlnshttp://www.w3.org/1999/xhtml xmlns:bhttp://www.google.com/2005/gml/b xmlns:datahttp://www.google.com/2005/gml/data xmlns:exprhttp://www.google.com/2005/gml/expr>head>link hrefhttps://www.blogger.com/static/v1/widgets/55013136-widget_css_bundle.css relstylesheet typetext/css/>meta contenttext/html; charsetUTF-8 http-equivContent-Type/>meta contentblogger namegenerator/>link hrefhttps://www.dbaglobe.com/favicon.ico relicon typeimage/x-icon/>link hrefhttps://www.dbaglobe.com/ relcanonical/>link relalternate typeapplication/atom+xml titleDonghua's Blog - DBAGlobe - Atom hrefhttps://www.dbaglobe.com/feeds/posts/default />link relalternate typeapplication/rss+xml titleDonghua's Blog - DBAGlobe - RSS hrefhttps://www.dbaglobe.com/feeds/posts/default?altrss />link relservice.post typeapplication/atom+xml titleDonghua's Blog - DBAGlobe - Atom hrefhttps://www.blogger.com/feeds/8091710565846343105/posts/default />link relme hrefhttps://www.blogger.com/profile/09892213541160033846 />!--Cant find substitution for tag blog.ieCssRetrofitLinks-->meta contentA blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. namedescription/>meta contenthttps://www.dbaglobe.com/ propertyog:url/>meta contentDonghua's Blog - DBAGlobe propertyog:title/>meta contentA blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. propertyog:description/>title>Donghuas Blog - DBAGlobe/title>style idpage-skin-1 typetext/css>!--/*-----------------------------------------------Blogger Template StyleName: Stretch DenimDesigner: Darren DelayeURL: www.DarrenDelaye.comDate: 11 Jul 2006-----------------------------------------------*//* Variable definitionsVariable namebgColor descriptionPage Background Colortypecolor default#efefef>Variable nametextColor descriptionText Colortypecolor default#333333>Variable namelinkColor descriptionLink Colortypecolor default#336699>Variable nameheaderBgColor descriptionPage Header Background Colortypecolor default#336699>Variable nameheaderTextColor descriptionPage Header Text Colortypecolor default#ffffff>Variable nameheaderCornersColor descriptionPage Header Corners Colortypecolor default#528bc5>Variable namemainBgColor descriptionMain Background Colortypecolor default#ffffff>Variable nameborderColor descriptionBorder Colortypecolor default#cccccc>Variable namedateHeaderColor descriptionDate Header Colortypecolor default#999999>Variable namesidebarTitleBgColor descriptionSidebar Title Background Colortypecolor default#ffd595>Variable namesidebarTitleTextColor descriptionSidebar Title Text Colortypecolor default#333333>Variable namebodyFont descriptionText Fonttypefont defaultnormal normal 100% Verdana, Arial, Sans-serif;>Variable nameheaderFont descriptionPage Header Fonttypefont defaultnormal normal 210% Verdana, Arial, Sans-serif;>Variable namestartSide descriptionStart side in blog languagetypeautomatic defaultleft>Variable nameendSide descriptionEnd side in blog languagetypeautomatic defaultright>*/body, .body-fauxcolumn-outer {background: #efefef;margin: 0;padding: 0px;font: x-small Verdana, Arial;text-align: center;color: #333333;font-size/* */:/**/small;font-size: /**/small;}a:link {color: #336699;}a:visited {color: #336699;}a img {border-width: 0;}#outer-wrapper {font: normal normal 100% Verdana, Arial, Sans-serif;;}/* Header----------------------------------------------- */#header-wrapper {margin:0;padding: 0;background-color: #528bc5;text-align: left;}#header {margin: 0 2%;background-color: #336699;color: #ffffff;padding: 0;font: normal normal 210% Verdana, Arial, Sans-serif;;position: relative;}h1.title {padding-top: 38px;margin: 0 1% .1em;line-height: 1.2em;font-size: 100%;}h1.title a, h1.title a:visited {color: #ffffff;text-decoration: none;}#header .description {display: block;margin: 0 1%;padding: 0 0 40px;line-height: 1.4em;font-size: 50%;}/* Content----------------------------------------------- */.clear {clear: both;}#content-wrapper {margin: 0 2%;padding: 0 0 15px;text-align: left;background-color: #ffffff;border: 1px solid #cccccc;border-top: 0;}#main-wrapper {margin-left: 1%;width: 64%;float: left;background-color: #ffffff;display: inline; /* fix for doubling margin in IE */word-wrap: break-word; /* fix for long text breaking sidebar float in IE */overflow: hidden; /* fix for long non-text content breaking IE sidebar float */}#sidebar-wrapper {margin-right: 1%;width: 29%;float: right;background-color: #ffffff;display: inline; /* fix for doubling margin in IE */word-wrap: break-word; /* fix for long text breaking sidebar float in IE */overflow: hidden; /* fix for long non-text content breaking IE sidebar float */}/* Headings----------------------------------------------- */h2, h3 {margin: 0;}/* Posts----------------------------------------------- */.date-header {margin: 1.5em 0 0;font-weight: normal;color: #999999;font-size: 100%;}.post {margin: 0 0 1.5em;padding-bottom: 1.5em;}.post-title {margin: 0;padding: 0;font-size: 125%;font-weight: bold;line-height: 1.1em;}.post-title a, .post-title a:visited, .post-title strong {text-decoration: none;color: #333333;font-weight: bold;}.post div {margin: 0 0 .75em;line-height: 1.3em;}.post-footer {margin: -.25em 0 0;color: #333333;font-size: 87%;}.post-footer .span {margin-right: .3em;}.post img, table.tr-caption-container {padding: 4px;border: 1px solid #cccccc;}.tr-caption-container img {border: none;padding: 0;}.post blockquote {margin: 1em 20px;}.post blockquote p {margin: .75em 0;}/* Comments----------------------------------------------- */#comments h4 {margin: 1em 0;color: #999999;}#comments h4 strong {font-size: 110%;}#comments-block {margin: 1em 0 1.5em;line-height: 1.3em;}#comments-block dt {margin: .5em 0;}#comments-block dd {margin: .25em 0 0;}#comments-block dd.comment-footer {margin: -.25em 0 2em;line-height: 1.4em;font-size: 78%;}#comments-block dd p {margin: 0 0 .75em;}.deleted-comment {font-style:italic;color:gray;}.feed-links {clear: both;line-height: 2.5em;}#blog-pager-newer-link {float: left;}#blog-pager-older-link {float: right;}#blog-pager {text-align: center;}/* Sidebar Content----------------------------------------------- */.sidebar h2 {margin: 1.6em 0 .5em;padding: 4px 5px;background-color: #ffd595;font-size: 100%;color: #333333;}.sidebar ul {margin: 0;padding: 0;list-style: none;}.sidebar li {margin: 0;padding-top: 0;padding-right: 0;padding-bottom: .5em;padding-left: 15px;text-indent: -15px;line-height: 1.5em;}.sidebar {color: #333333;line-height:1.3em;}.sidebar .widget {margin-bottom: 1em;}.sidebar .widget-content {margin: 0 5px;}/* Profile----------------------------------------------- */.profile-img {float: left;margin-top: 0;margin-right: 5px;margin-bottom: 5px;margin-left: 0;padding: 4px;border: 1px solid #cccccc;}.profile-data {margin:0;text-transform:uppercase;letter-spacing:.1em;font-weight: bold;line-height: 1.6em;font-size: 78%;}.profile-datablock {margin:.5em 0 .5em;}.profile-textblock {margin: 0.5em 0;line-height: 1.6em;}/* Footer----------------------------------------------- */#footer {clear: both;text-align: center;color: #333333;}#footer .widget {margin:.5em;padding-top: 20px;font-size: 85%;line-height: 1.5em;text-align: left;}/** Page structure tweaks for layout editor wireframe */body#layout #header {width: 750px;}-->/style>link hrefhttps://www.blogger.com/dyn-css/authorization.css?targetBlogID8091710565846343105&zxe45a50b1-68f8-47a8-9c58-c2589b8b89a4 medianone onloadif(media!'all')media'all' relstylesheet/>noscript>link hrefhttps://www.blogger.com/dyn-css/authorization.css?targetBlogID8091710565846343105&zxe45a50b1-68f8-47a8-9c58-c2589b8b89a4 relstylesheet/>/noscript>meta namegoogle-adsense-platform-account contentca-host-pub-1556223355139109/>meta namegoogle-adsense-platform-domain contentblogspot.com/>!-- data-ad-clientca-pub-6105119525288020 -->/head>body>div classnavbar section idnavbar>div classwidget Navbar data-version1 idNavbar1>script typetext/javascript> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener(load, function(){ objectattribute val; }, false); } else { window.attachEvent(onload, function(){ objectattribute val; }); } } /script>div idnavbar-iframe-container>/div>script typetext/javascript srchttps://apis.google.com/js/platform.js>/script>script typetext/javascript> gapi.load(gapi.iframes:gapi.iframes.style.bubble, function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: https://www.blogger.com/navbar.g?targetBlogID\x3d8091710565846343105\x26blogName\x3dDonghua\x27s+Blog+-+DBAGlobe\x26publishMode\x3dPUBLISH_MODE_HOSTED\x26navbarType\x3dBLUE\x26layoutType\x3dLAYOUTS\x26searchRoot\x3dhttps://www.dbaglobe.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttps://www.dbaglobe.com/\x26vt\x3d-7927138373008391015, where: document.getElementById(navbar-iframe-container), id: navbar-iframe }); } }); /script>script typetext/javascript>(function() {var script document.createElement(script);script.type text/javascript;script.src //pagead2.googlesyndication.com/pagead/js/google_top_exp.js;var head document.getElementsByTagName(head)0;if (head) {head.appendChild(script);}})();/script>/div>/div>div idouter-wrapper>div idwrap2>!-- skip links for text browsers -->span idskiplinks styledisplay:none;>a href#main>skip to main /a> | a href#sidebar>skip to sidebar/a>/span>div idheader-wrapper>div classheader section idheader>div classwidget Header data-version1 idHeader1>div idheader-inner>div classtitlewrapper>h1 classtitle>Donghuas Blog - DBAGlobe/h1>/div>div classdescriptionwrapper>p classdescription>span>Database, Information Architecture, Data Management, etc. Focus on new technologies and performance tuning/span>/p>/div>/div>/div>/div>/div>div idcontent-wrapper>div idcrosscol-wrapper styletext-align:center>div classcrosscol no-items section idcrosscol>/div>/div>div idmain-wrapper>div classmain section idmain>div classwidget Blog data-version1 idBlog1>div classblog-posts hfeed> div classdate-outer> h2 classdate-header>span>Monday, July 8, 2024/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name1330531126190952167>/a>h3 classpost-title entry-title>a hrefhttps://www.dbaglobe.com/2024/07/performance-validation-for-uuidv7.html>Performance validation for UUIDv7 implemented using SQL in PostgreSQL v16/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content idpost-body-1330531126190952167>p classcode-line data-line0 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Source code for UUIDv7 for PostgreSQL: a data-hrefhttps://gist.github.com/fabiolimace/515a0440e3e40efeb234e12644a6a346 hrefhttps://gist.github.com/fabiolimace/515a0440e3e40efeb234e12644a6a346 stylecolor: var(--vscode-textLink-foreground); text-decoration: var(--text-link-decoration);>https://gist.github.com/fabiolimace/515a0440e3e40efeb234e12644a6a346/a>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line4 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>or/span> replace span classhljs-keyword stylecolor: blue;>function/span> uuid7() span classhljs-keyword stylecolor: blue;>returns/span> uuid span classhljs-keyword stylecolor: blue;>as/span> $$span classhljs-keyword stylecolor: blue;>declare/span>span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>return/span> uuid7(clock_timestamp());span classhljs-keyword stylecolor: blue;>end/span> $$ span classhljs-keyword stylecolor: blue;>language/span> plpgsql;/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line13 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>or/span> replace span classhljs-keyword stylecolor: blue;>function/span> uuid7(p_timestamp span classhljs-type stylecolor: #a31515;>timestamp/span> span classhljs-keyword stylecolor: blue;>with/span> span classhljs-type stylecolor: #a31515;>time/span> zone) span classhljs-keyword stylecolor: blue;>returns/span> uuid span classhljs-keyword stylecolor: blue;>as/span> $$span classhljs-keyword stylecolor: blue;>declare/span> v_time span classhljs-type stylecolor: #a31515;>double precision/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; v_unix_t span classhljs-type stylecolor: #a31515;>bigint/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; v_rand_a span classhljs-type stylecolor: #a31515;>bigint/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; v_rand_b span classhljs-type stylecolor: #a31515;>bigint/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; v_unix_t_hex span classhljs-type stylecolor: #a31515;>varchar/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; v_rand_a_hex span classhljs-type stylecolor: #a31515;>varchar/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; v_rand_b_hex span classhljs-type stylecolor: #a31515;>varchar/span> :span classhljs-operator>/span> span classhljs-keyword stylecolor: blue;>null/span>; c_milli span classhljs-type stylecolor: #a31515;>double precision/span> :span classhljs-operator>/span> span classhljs-number stylecolor: green;>10/span>span classhljs-operator>^/span>span classhljs-number stylecolor: green;>3/span>; span classhljs-comment stylecolor: green; font-style: italic;>-- 1 000/span> c_micro span classhljs-type stylecolor: #a31515;>double precision/span> :span classhljs-operator>/span> span classhljs-number stylecolor: green;>10/span>span classhljs-operator>^/span>span classhljs-number stylecolor: green;>6/span>; span classhljs-comment stylecolor: green; font-style: italic;>-- 1 000 000/span> c_scale span classhljs-type stylecolor: #a31515;>double precision/span> :span classhljs-operator>/span> span classhljs-number stylecolor: green;>4.096/span>; span classhljs-comment stylecolor: green; font-style: italic;>-- 4.0 * (1024 / 1000)/span> c_version span classhljs-type stylecolor: #a31515;>bigint/span> :span classhljs-operator>/span> xspan classhljs-string stylecolor: #a31515;>0000000000007000/span>::span classhljs-type stylecolor: #a31515;>bigint/span>; span classhljs-comment stylecolor: green; font-style: italic;>-- RFC-9562 version: b0111.../span> c_variant span classhljs-type stylecolor: #a31515;>bigint/span> :span classhljs-operator>/span> xspan classhljs-string stylecolor: #a31515;>8000000000000000/span>::span classhljs-type stylecolor: #a31515;>bigint/span>; span classhljs-comment stylecolor: green; font-style: italic;>-- RFC-9562 variant: b10xx.../span>span classhljs-keyword stylecolor: blue;>begin/span> v_time :span classhljs-operator>/span> span classhljs-built_in stylecolor: #007acc;>extract/span>(epoch span classhljs-keyword stylecolor: blue;>from/span> p_timestamp); v_unix_t :span classhljs-operator>/span> trunc(v_time span classhljs-operator>*/span> c_milli); v_rand_a :span classhljs-operator>/span> trunc((v_time span classhljs-operator>*/span> c_micro span classhljs-operator>-/span> v_unix_t span classhljs-operator>*/span> c_milli) span classhljs-operator>*/span> c_scale); v_rand_b :span classhljs-operator>/span> trunc(random() span classhljs-operator>*/span> span classhljs-number stylecolor: green;>2/span>span classhljs-operator>^/span>span classhljs-number stylecolor: green;>30/span>)::span classhljs-type stylecolor: #a31515;>bigint/span> span classhljs-operator><</span> span classhljs-number stylecolor: green;>32/span> span classhljs-operator>|/span> trunc(random() span classhljs-operator>*/span> span classhljs-number stylecolor: green;>2/span>span classhljs-operator>^/span>span classhljs-number stylecolor: green;>32/span>)::span classhljs-type stylecolor: #a31515;>bigint/span>; v_unix_t_hex :span classhljs-operator>/span> lpad(to_hex(v_unix_t), span classhljs-number stylecolor: green;>12/span>, span classhljs-string stylecolor: #a31515;>0/span>); v_rand_a_hex :span classhljs-operator>/span> lpad(to_hex((v_rand_a span classhljs-operator>|/span> c_version)::span classhljs-type stylecolor: #a31515;>bigint/span>), span classhljs-number stylecolor: green;>4/span>, span classhljs-string stylecolor: #a31515;>0/span>); v_rand_b_hex :span classhljs-operator>/span> lpad(to_hex((v_rand_b span classhljs-operator>|/span> c_variant)::span classhljs-type stylecolor: #a31515;>bigint/span>), span classhljs-number stylecolor: green;>16/span>, span classhljs-string stylecolor: #a31515;>0/span>); span classhljs-keyword stylecolor: blue;>return/span> (v_unix_t_hex span classhljs-operator>||/span> v_rand_a_hex span classhljs-operator>||/span> v_rand_b_hex)::uuid; span classhljs-keyword stylecolor: blue;>end/span> $$ span classhljs-keyword stylecolor: blue;>language/span> plpgsql;/code>/pre>h2 classcode-line data-line52 dirauto idperformance-testing styleborder-bottom-style: solid; border-bottom-width: 1px; border-color: rgba(0, 0, 0, 0.18); color: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; padding-bottom: 0.3em; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Performance Testing/h2>h4 classcode-line data-line54 dirauto idtesting-for-uuid-generation stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Testing for UUID generation/h4>p classcode-line data-line56 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>strong>Setup/strong>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line57 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>do$$span classhljs-keyword stylecolor: blue;>declare/span> u uuid;span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>for/span> i span classhljs-keyword stylecolor: blue;>in/span> span classhljs-number stylecolor: green;>1./span>span classhljs-number stylecolor: green;>.10000000/span> loop span classhljs-keyword stylecolor: blue;>select/span> gen_random_uuid() span classhljs-keyword stylecolor: blue;>into/span> u;span classhljs-comment stylecolor: green; font-style: italic;>-- raise notice %, u;/span> span classhljs-keyword stylecolor: blue;>end/span> loop;span classhljs-keyword stylecolor: blue;>end/span>;$$;/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line71 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>do$$span classhljs-keyword stylecolor: blue;>declare/span> u uuid;span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>for/span> i span classhljs-keyword stylecolor: blue;>in/span> span classhljs-number stylecolor: green;>1./span>span classhljs-number stylecolor: green;>.10000000/span> loop span classhljs-keyword stylecolor: blue;>select/span> uuid7() span classhljs-keyword stylecolor: blue;>into/span> u;span classhljs-comment stylecolor: green; font-style: italic;>-- raise notice %, u;/span> span classhljs-keyword stylecolor: blue;>end/span> loop;span classhljs-keyword stylecolor: blue;>end/span>;$$;/code>/pre>p classcode-line data-line85 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>strong>Test/strong>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line87 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># domytestspan classhljs-operator>-/span># $$mytest$# span classhljs-keyword stylecolor: blue;>declare/span>mytest$# u uuid;mytest$# span classhljs-keyword stylecolor: blue;>begin/span>mytest$# span classhljs-keyword stylecolor: blue;>for/span> i span classhljs-keyword stylecolor: blue;>in/span> span classhljs-number stylecolor: green;>1./span>span classhljs-number stylecolor: green;>.10000000/span>mytest$# loopmytest$# span classhljs-keyword stylecolor: blue;>select/span> gen_random_uuid() span classhljs-keyword stylecolor: blue;>into/span> u;mytest$# span classhljs-comment stylecolor: green; font-style: italic;>-- raise notice %, u;/span>mytest$# span classhljs-keyword stylecolor: blue;>end/span> loop;mytest$# span classhljs-keyword stylecolor: blue;>end/span>;mytest$# $$;DOspan classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>31743.056/span> ms (span classhljs-number stylecolor: green;>00/span>:span classhljs-number stylecolor: green;>31.743/span>)span classhljs-comment stylecolor: green; font-style: italic;>-- each execution 0.031743056ms/span>/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line104 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># domytestspan classhljs-operator>-/span># $$mytest$# span classhljs-keyword stylecolor: blue;>declare/span>mytest$# u uuid;mytest$# span classhljs-keyword stylecolor: blue;>begin/span>mytest$# span classhljs-keyword stylecolor: blue;>for/span> i span classhljs-keyword stylecolor: blue;>in/span> span classhljs-number stylecolor: green;>1./span>span classhljs-number stylecolor: green;>.10000000/span>mytest$# loopmytest$# span classhljs-keyword stylecolor: blue;>select/span> uuid7() span classhljs-keyword stylecolor: blue;>into/span> u;mytest$# span classhljs-comment stylecolor: green; font-style: italic;>-- raise notice %, u;/span>mytest$# span classhljs-keyword stylecolor: blue;>end/span> loop;mytest$# span classhljs-keyword stylecolor: blue;>end/span>;mytest$# $$;DOspan classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>54132.676/span> ms (span classhljs-number stylecolor: green;>00/span>:span classhljs-number stylecolor: green;>54.133/span>)span classhljs-comment stylecolor: green; font-style: italic;>-- each execution 0.054132676ms/span>/code>/pre>h4 classcode-line data-line123 dirauto idtesting-for-uuid-insertion stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Testing for UUID insertion/h4>p classcode-line data-line125 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>strong>Setup/strong>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line127 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>table/span> tbl_uuidv4 (u uuid span classhljs-keyword stylecolor: blue;>primary/span> key, c text);span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv4span classhljs-keyword stylecolor: blue;>select/span> gen_random_uuid(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>10000000/span>);/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line134 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>table/span> tbl_uuidv7 (u uuid span classhljs-keyword stylecolor: blue;>primary/span> key, c text);span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv7span classhljs-keyword stylecolor: blue;>select/span> uuid7(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>10000000/span>);/code>/pre>p classcode-line data-line141 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>strong>Test/strong>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line143 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv4mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>select/span> gen_random_uuid(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>10000000/span>);span classhljs-keyword stylecolor: blue;>INSERT/span> span classhljs-number stylecolor: green;>0/span> span classhljs-number stylecolor: green;>10000000/span>span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>60405.272/span> ms (span classhljs-number stylecolor: green;>01/span>:span classhljs-number stylecolor: green;>00.405/span>)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line149 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv7mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>select/span> uuid7(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>10000000/span>);span classhljs-keyword stylecolor: blue;>INSERT/span> span classhljs-number stylecolor: green;>0/span> span classhljs-number stylecolor: green;>10000000/span>span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>56902.619/span> ms (span classhljs-number stylecolor: green;>00/span>:span classhljs-number stylecolor: green;>56.903/span>)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line157 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># \dtspan classhljs-operator>+/span> tbl_uuidspan classhljs-operator>*/span> List span classhljs-keyword stylecolor: blue;>of/span> relations Schema span classhljs-operator>|/span> Name span classhljs-operator>|/span> Type span classhljs-operator>|/span> Owner span classhljs-operator>|/span> Persistence span classhljs-operator>|/span> Access span classhljs-keyword stylecolor: blue;>method/span> span classhljs-operator>|/span> Size span classhljs-operator>|/span> Descriptionspan classhljs-comment stylecolor: green; font-style: italic;>--------+------------+-------+----------+-------------+---------------+--------+-------------/span> public span classhljs-operator>|/span> tbl_uuidv4 span classhljs-operator>|/span> span classhljs-keyword stylecolor: blue;>table/span> span classhljs-operator>|/span> donghua span classhljs-operator>|/span> permanent span classhljs-operator>|/span> heap span classhljs-operator>|/span> span classhljs-number stylecolor: green;>575/span> MB span classhljs-operator>|/span> public span classhljs-operator>|/span> tbl_uuidv7 span classhljs-operator>|/span> span classhljs-keyword stylecolor: blue;>table/span> span classhljs-operator>|/span> donghua span classhljs-operator>|/span> permanent span classhljs-operator>|/span> heap span classhljs-operator>|/span> span classhljs-number stylecolor: green;>575/span> MB span classhljs-operator>|/span>(span classhljs-number stylecolor: green;>2/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line167 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># \dispan classhljs-operator>+/span> tbl_uuidspan classhljs-operator>*/span> List span classhljs-keyword stylecolor: blue;>of/span> relations Schema span classhljs-operator>|/span> Name span classhljs-operator>|/span> Type span classhljs-operator>|/span> Owner span classhljs-operator>|/span> span classhljs-keyword stylecolor: blue;>Table/span> span classhljs-operator>|/span> Persistence span classhljs-operator>|/span> Access span classhljs-keyword stylecolor: blue;>method/span> span classhljs-operator>|/span> Size span classhljs-operator>|/span> Descriptionspan classhljs-comment stylecolor: green; font-style: italic;>--------+-----------------+-------+----------+------------+-------------+---------------+--------+-------------/span> public span classhljs-operator>|/span> tbl_uuidv4_pkey span classhljs-operator>|/span> index span classhljs-operator>|/span> donghua span classhljs-operator>|/span> tbl_uuidv4 span classhljs-operator>|/span> permanent span classhljs-operator>|/span> btree span classhljs-operator>|/span> span classhljs-number stylecolor: green;>392/span> MB span classhljs-operator>|/span> public span classhljs-operator>|/span> tbl_uuidv7_pkey span classhljs-operator>|/span> index span classhljs-operator>|/span> donghua span classhljs-operator>|/span> tbl_uuidv7 span classhljs-operator>|/span> permanent span classhljs-operator>|/span> btree span classhljs-operator>|/span> span classhljs-number stylecolor: green;>301/span> MB span classhljs-operator>|/span>(span classhljs-number stylecolor: green;>2/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>h4 classcode-line data-line178 dirauto idtesting-how-many-buffers-dirtied-for-uuid-insertion stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Testing how many buffers dirtied for UUID insertion/h4>p classcode-line data-line180 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>strong>Setup/strong>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line182 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>explain (analyze,buffers)span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv4span classhljs-keyword stylecolor: blue;>select/span> gen_random_uuid(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>100/span>);/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line188 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>explain (analyze,buffers)span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv7span classhljs-keyword stylecolor: blue;>select/span> uuid7(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>100/span>);/code>/pre>p classcode-line data-line196 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>strong>Test/strong>/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line198 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># explain (analyze,buffers)mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv4mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>select/span> gen_random_uuid(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>100/span>); QUERY PLANspan classhljs-comment stylecolor: green; font-style: italic;>-------------------------------------------------------------------------------------------------------------------------------/span> span classhljs-keyword stylecolor: blue;>Insert/span> span classhljs-keyword stylecolor: blue;>on/span> tbl_uuidv4 (costspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0.00/span>.span classhljs-number stylecolor: green;>.2/span>span classhljs-number stylecolor: green;>.25/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0/span> widthspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0/span>) (actual span classhljs-type stylecolor: #a31515;>time/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>40.337/span>.span classhljs-number stylecolor: green;>.40/span>span classhljs-number stylecolor: green;>.338/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0/span> loopsspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span>) Buffers: shared hitspan classhljs-operator>/span>span classhljs-number stylecolor: green;>231/span> readspan classhljs-operator>/span>span classhljs-number stylecolor: green;>186/span> dirtiedspan classhljs-operator>/span>span classhljs-number stylecolor: green;>106/span> writtenspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span> span classhljs-operator>-/span>span classhljs-operator>>/span> Subquery Scan span classhljs-keyword stylecolor: blue;>on/span> *SELECT* (costspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0.00/span>.span classhljs-number stylecolor: green;>.2/span>span classhljs-number stylecolor: green;>.25/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> widthspan classhljs-operator>/span>span classhljs-number stylecolor: green;>48/span>) (actual span classhljs-type stylecolor: #a31515;>time/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0.038/span>.span classhljs-number stylecolor: green;>.1/span>span classhljs-number stylecolor: green;>.379/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> loopsspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span>) span classhljs-operator>-/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>Function/span> Scan span classhljs-keyword stylecolor: blue;>on/span> generate_series (costspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0.00/span>.span classhljs-number stylecolor: green;>.1/span>span classhljs-number stylecolor: green;>.25/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> widthspan classhljs-operator>/span>span classhljs-number stylecolor: green;>48/span>) (actual span classhljs-type stylecolor: #a31515;>time/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0.037/span>.span classhljs-number stylecolor: green;>.1/span>span classhljs-number stylecolor: green;>.306/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> loopsspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span>) Planning span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>0.048/span> ms Execution span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>40.365/span> ms(span classhljs-number stylecolor: green;>6/span> span classhljs-keyword stylecolor: blue;>rows/span>)span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>41.754/span> ms/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap-mode: wrap; widows: 2;>code classcode-line language-sql data-line215 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 0px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># explain (analyze,buffers)mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> tbl_uuidv7mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>select/span> uuid7(), span classhljs-string stylecolor: #a31515;>additional data/span> span classhljs-keyword stylecolor: blue;>from/span> generate_series(span classhljs-number stylecolor: green;>1/span>,span classhljs-number stylecolor: green;>100/span>); QUERY PLANspan classhljs-comment stylecolor: green; font-style: italic;>--------------------------------------------------------------------------------------------------------------------------------/span> span classhljs-keyword stylecolor: blue;>Insert/span> span classhljs-keyword stylecolor: blue;>on/span> tbl_uuidv7 (costspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0.00/span>.span classhljs-number stylecolor: green;>.27/span>span classhljs-number stylecolor: green;>.00/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0/span> widthspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0/span>) (actual span classhljs-type stylecolor: #a31515;>time/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>1.204/span>.span classhljs-number stylecolor: green;>.1/span>span classhljs-number stylecolor: green;>.205/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0/span> loopsspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span>) Buffers: shared hitspan classhljs-operator>/span>span classhljs-number stylecolor: green;>219/span> dirtiedspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span> writtenspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span> span classhljs-operator>-/span>span classhljs-operator>>/span> Subquery Scan span classhljs-keyword stylecolor: blue;>on/span> *SELECT* (costspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0.00/span>.span classhljs-number stylecolor: green;>.27/span>span classhljs-number stylecolor: green;>.00/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> widthspan classhljs-operator>/span>span classhljs-number stylecolor: green;>48/span>) (actual span classhljs-type stylecolor: #a31515;>time/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0.077/span>.span classhljs-number stylecolor: green;>.0/span>span classhljs-number stylecolor: green;>.614/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> loopsspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span>) span classhljs-operator>-/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>Function/span> Scan span classhljs-keyword stylecolor: blue;>on/span> generate_series (costspan classhljs-operator>/span>span classhljs-number stylecolor: green;>0.00/span>.span classhljs-number stylecolor: green;>.26/span>span classhljs-number stylecolor: green;>.00/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> widthspan classhljs-operator>/span>span classhljs-number stylecolor: green;>48/span>) (actual span classhljs-type stylecolor: #a31515;>time/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>0.076/span>.span classhljs-number stylecolor: green;>.0/span>span classhljs-number stylecolor: green;>.594/span> span classhljs-keyword stylecolor: blue;>rows/span>span classhljs-operator>/span>span classhljs-number stylecolor: green;>100/span> loopsspan classhljs-operator>/span>span classhljs-number stylecolor: green;>1/span>) Planning span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>0.036/span> ms Execution span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>1.227/span> ms(span classhljs-number stylecolor: green;>6/span> span classhljs-keyword stylecolor: blue;>rows/span>)span classhljs-type stylecolor: #a31515;>Time/span>: span classhljs-number stylecolor: green;>1.904/span> ms/code>/pre>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-author vcard>Posted byspan classfn>Luo Donghua/span>/span>span classpost-timestamp>ata classtimestamp-link hrefhttps://www.dbaglobe.com/2024/07/performance-validation-for-uuidv7.html relbookmark titlepermanent link>abbr classpublished title2024-07-08T22:00:00+08:00>10:00 PM/abbr>/a>/span>span classpost-comment-link>a classcomment-link hrefhttps://www.dbaglobe.com/2024/07/performance-validation-for-uuidv7.html#comment-form onclick>0comments/a>/span>span classpost-icons>span classitem-control blog-admin pid-1645370588>a hrefhttps://www.blogger.com/post-edit.g?blogID8091710565846343105&postID1330531126190952167&frompencil titleEdit Post>img alt classicon-action height18 srchttps://resources.blogblog.com/img/icon18_edit_allbkg.gif width18/>/a>/span>/span>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttps://www.dbaglobe.com/search/label/Postgresql reltag>Postgresql/a>/span>/div>div classpost-footer-line post-footer-line-3>span classpost-location>/span>/div>/div>/div>/div>div classinline-ad>script async srchttps://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js>/script>!-- dbaglobe_main_Blog1_1x1_as -->ins classadsbygoogle styledisplay:block data-ad-clientca-pub-6105119525288020 data-ad-hostca-host-pub-1556223355139109 data-ad-host-channelL0007 data-ad-slot4773661092 data-ad-formatauto data-full-width-responsivetrue>/ins>script>(adsbygoogle window.adsbygoogle || ).push({});/script>/div> /div>/div> div classdate-outer> h2 classdate-header>span>Sunday, May 12, 2024/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name941492489903247459>/a>h3 classpost-title entry-title>a hrefhttps://www.dbaglobe.com/2024/05/install-postgresql-server-or-client-on.html>Install PostgreSQL Server or Client on MacOS for testing purpose/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content idpost-body-941492489903247459>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>p stylebox-sizing: border-box; margin: 0px 0px 1.2em;>The default PostgreSQL installation for MacOS is via installer packaged by EDB, provides more features and easier for beginners. Personally I prefer to have PostgreSQL installed in specified folders, easier to manage multiple versions co-exists on my laptop and easier to uninstall and upgrade./p>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>ol stylebox-sizing: border-box; margin: 1.2em 0px;>li stylebox-sizing: border-box;>Download PostgreSQL binaries archive./li>/ol>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>p stylebox-sizing: border-box; margin: 1.2em 0px;>Link: a hrefhttps://www.enterprisedb.com/download-postgresql-binaries stylebox-sizing: border-box; color: #0c93e4; text-decoration-skip-ink: auto;>https://www.enterprisedb.com/download-postgresql-binaries/a>/p>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>ol start2 stylebox-sizing: border-box; margin: 1.2em 0px;>li stylebox-sizing: border-box;>Unzip them to a folder. Here it will unzip into code stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: 0.85em; padding: 2px 4px;>/Users/donghua/Tools/pgsql/code>/li>/ol>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>pre class language-bash stylebox-sizing: border-box; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: 0.85em; margin-bottom: 1.2em; margin-top: 1.2em;>code classprism language-bash stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; display: block; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: inherit; overflow-x: auto; padding: 0.5em;>unzip postgresql-16.3-1-osx-binaries.zip -d /Users/donghua/Tools/code>/pre>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>ol start3 stylebox-sizing: border-box; margin: 1.2em 0px;>li stylebox-sizing: border-box;>Fix com.apple.quarantine issue on MacOS/li>/ol>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>pre class language-bash stylebox-sizing: border-box; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: 0.85em; margin-bottom: 1.2em; margin-top: 1.2em;>code classprism language-bash stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; display: block; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: inherit; overflow-x: auto; padding: 0.5em;>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>sudo/span> xattr -dr com.apple.quarantine span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span> /Users/donghua/Tools/pgsqlspan classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>for/span> i span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>in/span> span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>span classtoken variable stylebox-sizing: border-box; font-size: inherit;>`/span>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>find/span> /Users/donghua/Tools/pgsql/bin -type fspan classtoken variable stylebox-sizing: border-box; font-size: inherit;>`/span>/span>span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>do/span> span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>ls/span> -l@ span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span>span classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>|/span>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>grep/span> com.apple.quarantine span classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>>/span> /dev/null span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>if/span> span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span>span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span> span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$?/span> -eq 0 span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span>span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span> span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>then/span> print span classtoken string stylebox-sizing: border-box; color: #669900; font-size: inherit;>File quarantine: span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span>/span> span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>sudo/span> xattr -d com.apple.quarantine span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span> span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>fi/span>span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>done/span>span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>for/span> i span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>in/span> span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>span classtoken variable stylebox-sizing: border-box; font-size: inherit;>`/span>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>find/span> /Users/donghua/Tools/pgsql/lib -type fspan classtoken variable stylebox-sizing: border-box; font-size: inherit;>`/span>/span>span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>do/span> span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>ls/span> -l@ span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span>span classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>|/span>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>grep/span> com.apple.quarantine span classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>>/span> /dev/null span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>if/span> span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span>span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span> span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$?/span> -eq 0 span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span>span classtoken punctuation stylebox-sizing: border-box; color: #999999; font-size: inherit;>/span> span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>then/span> print span classtoken string stylebox-sizing: border-box; color: #669900; font-size: inherit;>File quarantine: span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span>/span> span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>sudo/span> xattr -d com.apple.quarantine span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$i/span> span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>fi/span>span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: inherit;>done/span>/code>/pre>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>ol start4 stylebox-sizing: border-box; margin: 1.2em 0px;>li stylebox-sizing: border-box;>Setup your environment variables./li>/ol>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>p stylebox-sizing: border-box; margin: 1.2em 0px;>Here I use code stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: 0.85em; padding: 2px 4px;>zsh/code>, put below entries to code stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: 0.85em; padding: 2px 4px;>~/.zprofile/code>/p>/div>div classcl-preview-section stylebox-sizing: border-box; caret-color: rgba(0, 0, 0, 0.75); color: rgba(0, 0, 0, 0.75); font-family: Lato, "Helvetica Neue", Helvetica, sans-serif; font-size: 18px;>pre class language-bash stylebox-sizing: border-box; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: 0.85em; margin-bottom: 1.2em; margin-top: 1.2em;>code classprism language-bash stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; display: block; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: inherit; overflow-x: auto; padding: 0.5em;>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>export/span> PGHOMEspan classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>/span>/Users/donghua/Tools/pgsqlspan classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>export/span> PGDATAspan classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>/span>/Users/donghua/Tools/pgdata/16/data/code>code classprism language-bash stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; display: block; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: inherit; overflow-x: auto; padding: 0.5em;>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: 15.3px;>export/span>span stylefont-size: 15.3px;> PATH/span>span classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: 15.3px;>/span>span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: 15.3px;>$PATH/span>span classtoken keyword stylebox-sizing: border-box; color: #0077aa; font-size: 15.3px;>:/span>span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: 15.3px;>$PGHOME/span>span stylefont-size: 15.3px;>/bin/span>/code>code classprism language-bash stylebackground-color: rgba(0, 0, 0, 0.05); border-radius: 3px; box-sizing: border-box; display: block; font-family: "Roboto Mono", "Lucida Sans Typewriter", "Lucida Console", monaco, Courrier, monospace; font-size: inherit; overflow-x: auto; padding: 0.5em;>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>alias/span> pgadmin4span classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>/span>span classtoken string stylebox-sizing: border-box; color: #669900; font-size: inherit;>open -a /Users/donghua/Tools/pgsql/pgAdmin 4.app/span>span classtoken function stylebox-sizing: border-box; color: #dd4a68; font-size: inherit;>alias/span> pglogspan classtoken operator stylebox-sizing: border-box; color: #a67f59; font-size: inherit;>/span>span classtoken string stylebox-sizing: border-box; color: #669900; font-size: inherit;>cd span classtoken variable stylebox-sizing: border-box; color: #ee9900; font-size: inherit;>$PGDATA/span>/log/;ls -1t | head -n 1 | xargs tail -f/span>/code>/pre>/div>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-author vcard>Posted byspan classfn>Luo Donghua/span>/span>span classpost-timestamp>ata classtimestamp-link hrefhttps://www.dbaglobe.com/2024/05/install-postgresql-server-or-client-on.html relbookmark titlepermanent link>abbr classpublished title2024-05-12T09:31:00+08:00>9:31 AM/abbr>/a>/span>span classpost-comment-link>a classcomment-link hrefhttps://www.dbaglobe.com/2024/05/install-postgresql-server-or-client-on.html#comment-form onclick>0comments/a>/span>span classpost-icons>span classitem-control blog-admin pid-1645370588>a hrefhttps://www.blogger.com/post-edit.g?blogID8091710565846343105&postID941492489903247459&frompencil titleEdit Post>img alt classicon-action height18 srchttps://resources.blogblog.com/img/icon18_edit_allbkg.gif width18/>/a>/span>/span>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttps://www.dbaglobe.com/search/label/Postgresql reltag>Postgresql/a>/span>/div>div classpost-footer-line post-footer-line-3>span classpost-location>/span>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>Saturday, February 10, 2024/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name8610504032875487662>/a>h3 classpost-title entry-title>a hrefhttps://www.dbaglobe.com/2024/02/error-duplicate-key-value-violates.html> ERROR: duplicate key value violates unique constraint in PostgreSQL but not in Oracle/SQLServer/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content idpost-body-8610504032875487662>p>span stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; orphans: 2; widows: 2;>In both Oracle and SQL Server, these non-deferrable constraints are evaluated at the statement completion, and it does allow intermediate state which could break constraint rules as long as final state at the statement completion is compliant./span>/p>p classcode-line data-line4 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>PostgreSQL implements this differently, and the output can depends on the physical data orders./p>h2 classcode-line data-line6 dirauto idpostgresql-example styleborder-bottom-style: solid; border-bottom-width: 1px; border-color: rgba(0, 0, 0, 0.18); color: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; padding-bottom: 0.3em; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>PostgreSQL Example/h2>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line8 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> version(); versionspan classhljs-comment stylecolor: green; font-style: italic;>------------------------------------------------------------------------------------------------------------------/span> PostgreSQL span classhljs-number stylecolor: green;>16.1/span> span classhljs-keyword stylecolor: blue;>on/span> x86_64span classhljs-operator>-/span>applespan classhljs-operator>-/span>darwin20span classhljs-number stylecolor: green;>.6/span>span classhljs-number stylecolor: green;>.0/span>, compiled span classhljs-keyword stylecolor: blue;>by/span> Apple clang version span classhljs-number stylecolor: green;>12.0/span>span classhljs-number stylecolor: green;>.5/span> (clangspan classhljs-number stylecolor: green;>-1205.0/span>span classhljs-number stylecolor: green;>.22/span>span classhljs-number stylecolor: green;>.9/span>), span classhljs-number stylecolor: green;>64/span>span classhljs-operator>-/span>bit(span classhljs-number stylecolor: green;>1/span> span classhljs-type stylecolor: #a31515;>row/span>)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line15 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>drop/span> span classhljs-keyword stylecolor: blue;>table/span> p;span classhljs-keyword stylecolor: blue;>DROP/span> span classhljs-keyword stylecolor: blue;>TABLE/span>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>table/span> p (id span classhljs-type stylecolor: #a31515;>int/span> span classhljs-keyword stylecolor: blue;>primary/span> key);span classhljs-keyword stylecolor: blue;>CREATE/span> span classhljs-keyword stylecolor: blue;>TABLE/span>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> p span classhljs-keyword stylecolor: blue;>values/span>(span classhljs-number stylecolor: green;>1/span>),(span classhljs-number stylecolor: green;>2/span>),(span classhljs-number stylecolor: green;>3/span>);span classhljs-keyword stylecolor: blue;>INSERT/span> span classhljs-number stylecolor: green;>0/span> span classhljs-number stylecolor: green;>3/span>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p; idspan classhljs-comment stylecolor: green; font-style: italic;>----/span> span classhljs-number stylecolor: green;>1/span> span classhljs-number stylecolor: green;>2/span> span classhljs-number stylecolor: green;>3/span>(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line30 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>update/span> p span classhljs-keyword stylecolor: blue;>set/span> idspan classhljs-operator>/span>idspan classhljs-operator>+/span>span classhljs-number stylecolor: green;>1/span>;ERROR: duplicate key span classhljs-keyword stylecolor: blue;>value/span> violates span classhljs-keyword stylecolor: blue;>unique/span> span classhljs-keyword stylecolor: blue;>constraint/span> p_pkeyDETAIL: Key (id)span classhljs-operator>/span>(span classhljs-number stylecolor: green;>2/span>) already exists./code>/pre>p classcode-line data-line35 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>If we update the table backwards, it would succeed. As showed in followed code:/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line36 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># do$$span classhljs-keyword stylecolor: blue;>declare/span> rec_p record; cur_p span classhljs-keyword stylecolor: blue;>cursor/span> span classhljs-keyword stylecolor: blue;>for/span> span classhljs-keyword stylecolor: blue;>select/span> id span classhljs-keyword stylecolor: blue;>from/span> p span classhljs-keyword stylecolor: blue;>order/span> span classhljs-keyword stylecolor: blue;>by/span> id span classhljs-keyword stylecolor: blue;>desc/span>;span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>open/span> cur_p; loop span classhljs-keyword stylecolor: blue;>fetch/span> cur_p span classhljs-keyword stylecolor: blue;>into/span> rec_p; exit span classhljs-keyword stylecolor: blue;>when/span> span classhljs-keyword stylecolor: blue;>not/span> found; span classhljs-keyword stylecolor: blue;>update/span> p span classhljs-keyword stylecolor: blue;>set/span> idspan classhljs-operator>/span>idspan classhljs-operator>+/span>span classhljs-number stylecolor: green;>1/span> span classhljs-keyword stylecolor: blue;>where/span> idspan classhljs-operator>/span>rec_p.id; span classhljs-keyword stylecolor: blue;>end/span> loop;span classhljs-keyword stylecolor: blue;>end/span>;$$ span classhljs-keyword stylecolor: blue;>language/span> plpgsql;DO/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line54 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p; idspan classhljs-comment stylecolor: green; font-style: italic;>----/span> span classhljs-number stylecolor: green;>4/span> span classhljs-number stylecolor: green;>3/span> span classhljs-number stylecolor: green;>2/span>(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>p classcode-line data-line63 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>If the data in different physical order, it would succeed too./p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line65 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>truncate/span> span classhljs-keyword stylecolor: blue;>table/span> p;span classhljs-keyword stylecolor: blue;>TRUNCATE/span> span classhljs-keyword stylecolor: blue;>TABLE/span>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> p span classhljs-keyword stylecolor: blue;>values/span>(span classhljs-number stylecolor: green;>3/span>),(span classhljs-number stylecolor: green;>2/span>),(span classhljs-number stylecolor: green;>1/span>);span classhljs-keyword stylecolor: blue;>INSERT/span> span classhljs-number stylecolor: green;>0/span> span classhljs-number stylecolor: green;>3/span>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p; idspan classhljs-comment stylecolor: green; font-style: italic;>----/span> span classhljs-number stylecolor: green;>3/span> span classhljs-number stylecolor: green;>2/span> span classhljs-number stylecolor: green;>1/span>(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line78 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>update/span> p span classhljs-keyword stylecolor: blue;>set/span> idspan classhljs-operator>/span>idspan classhljs-operator>+/span>span classhljs-number stylecolor: green;>1/span>;span classhljs-keyword stylecolor: blue;>UPDATE/span> span classhljs-number stylecolor: green;>3/span>/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line82 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p; idspan classhljs-comment stylecolor: green; font-style: italic;>----/span> span classhljs-number stylecolor: green;>4/span> span classhljs-number stylecolor: green;>3/span> span classhljs-number stylecolor: green;>2/span>(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>h2 classcode-line data-line92 dirauto idms-sql-server-example styleborder-bottom-style: solid; border-bottom-width: 1px; border-color: rgba(0, 0, 0, 0.18); color: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; padding-bottom: 0.3em; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>MS SQL Server Example/h2>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line93 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>oraclespan classhljs-variable stylecolor: green;>@ol/span> span classhljs-operator>~/span>$ sqlcmd span classhljs-operator>-/span>S localhost span classhljs-operator>-/span>U sa span classhljs-operator>-/span>C span classhljs-operator>-/span>P p_ssw0rd span classhljs-operator>-/span>d TestDBspan classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>select/span> @span classhljs-variable stylecolor: green;>@version/span>;span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> gospan classhljs-comment stylecolor: green; font-style: italic;>-------------------------------------------------------------------/span>Microsoft span classhljs-keyword stylecolor: blue;>SQL/span> Server span classhljs-number stylecolor: green;>2022/span> (RTMspan classhljs-operator>-/span>CU11) (KB5032679) span classhljs-operator>-/span> span classhljs-number stylecolor: green;>16.0/span>span classhljs-number stylecolor: green;>.4105/span>span classhljs-number stylecolor: green;>.2/span> (X64) Nov span classhljs-number stylecolor: green;>14/span> span classhljs-number stylecolor: green;>2023/span> span classhljs-number stylecolor: green;>18/span>:span classhljs-number stylecolor: green;>33/span>:span classhljs-number stylecolor: green;>19/span> Copyright (C) span classhljs-number stylecolor: green;>2022/span> Microsoft Corporation Developer Edition (span classhljs-number stylecolor: green;>64/span>span classhljs-operator>-/span>bit) span classhljs-keyword stylecolor: blue;>on/span> Linux (Oracle Linux Server span classhljs-number stylecolor: green;>9.3/span>) span classhljs-operator></span>X64span classhljs-operator>>/span>(span classhljs-number stylecolor: green;>1/span> span classhljs-keyword stylecolor: blue;>rows/span> affected)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line106 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>table/span> p (id span classhljs-type stylecolor: #a31515;>int/span> span classhljs-keyword stylecolor: blue;>primary/span> key);span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> gospan classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> t;span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> gospan classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p;span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> goidspan classhljs-comment stylecolor: green; font-style: italic;>-----------/span>(span classhljs-number stylecolor: green;>0/span> span classhljs-keyword stylecolor: blue;>rows/span> affected)span classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> p span classhljs-keyword stylecolor: blue;>values/span>(span classhljs-number stylecolor: green;>1/span>),(span classhljs-number stylecolor: green;>2/span>),(span classhljs-number stylecolor: green;>3/span>);span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> go(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span> affected)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line125 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>update/span> p span classhljs-keyword stylecolor: blue;>set/span> idspan classhljs-operator>/span>idspan classhljs-operator>+/span>span classhljs-number stylecolor: green;>1/span>;span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> go(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span> affected)/code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line131 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-number stylecolor: green;>1/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p;span classhljs-number stylecolor: green;>2/span>span classhljs-operator>>/span> goidspan classhljs-comment stylecolor: green; font-style: italic;>-----------/span> span classhljs-number stylecolor: green;>2/span> span classhljs-number stylecolor: green;>3/span> span classhljs-number stylecolor: green;>4/span>(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span> affected)/code>/pre>h2 classcode-line data-line144 dirauto idoracle-example styleborder-bottom-style: solid; border-bottom-width: 1px; border-color: rgba(0, 0, 0, 0.18); color: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; padding-bottom: 0.3em; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Oracle Example/h2>p classcode-line data-line146 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release Version 23.2.0.0.0/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line149 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>SQL/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>table/span> p (id span classhljs-type stylecolor: #a31515;>int/span> span classhljs-keyword stylecolor: blue;>primary/span> key);span classhljs-keyword stylecolor: blue;>Table/span> created.span classhljs-keyword stylecolor: blue;>SQL/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>insert/span> span classhljs-keyword stylecolor: blue;>into/span> p span classhljs-keyword stylecolor: blue;>values/span>(span classhljs-number stylecolor: green;>1/span>),(span classhljs-number stylecolor: green;>2/span>),(span classhljs-number stylecolor: green;>3/span>);span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span> created.span classhljs-keyword stylecolor: blue;>SQL/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>commit/span>;span classhljs-keyword stylecolor: blue;>Commit/span> complete./code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line163 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>SQL/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>update/span> p span classhljs-keyword stylecolor: blue;>set/span> idspan classhljs-operator>/span>idspan classhljs-operator>+/span>span classhljs-number stylecolor: green;>1/span>;span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span> updated.span classhljs-keyword stylecolor: blue;>SQL/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>commit/span>;span classhljs-keyword stylecolor: blue;>Commit/span> complete./code>/pre>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line172 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>SQL/span>span classhljs-operator>>/span> span classhljs-keyword stylecolor: blue;>select/span> span classhljs-operator>*/span> span classhljs-keyword stylecolor: blue;>from/span> p; IDspan classhljs-comment stylecolor: green; font-style: italic;>----------/span> span classhljs-number stylecolor: green;>2/span> span classhljs-number stylecolor: green;>3/span> span classhljs-number stylecolor: green;>4/span>/code>/pre>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-author vcard>Posted byspan classfn>Luo Donghua/span>/span>span classpost-timestamp>ata classtimestamp-link hrefhttps://www.dbaglobe.com/2024/02/error-duplicate-key-value-violates.html relbookmark titlepermanent link>abbr classpublished title2024-02-10T17:21:00+08:00>5:21 PM/abbr>/a>/span>span classpost-comment-link>a classcomment-link hrefhttps://www.dbaglobe.com/2024/02/error-duplicate-key-value-violates.html#comment-form onclick>0comments/a>/span>span classpost-icons>span classitem-control blog-admin pid-1645370588>a hrefhttps://www.blogger.com/post-edit.g?blogID8091710565846343105&postID8610504032875487662&frompencil titleEdit Post>img alt classicon-action height18 srchttps://resources.blogblog.com/img/icon18_edit_allbkg.gif width18/>/a>/span>/span>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttps://www.dbaglobe.com/search/label/Postgresql reltag>Postgresql/a>/span>/div>div classpost-footer-line post-footer-line-3>span classpost-location>/span>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>Tuesday, February 6, 2024/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name55417943897235568>/a>h3 classpost-title entry-title>a hrefhttps://www.dbaglobe.com/2024/02/how-to-keep-postgresql-sequences-value.html>How to keep PostgreSQL sequences value in sync via script/automation/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content idpost-body-55417943897235568>p> span stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; orphans: 2; widows: 2;>Sample scripts to demonstrate how to generate DDLs to keep sequences in sync between 2 PostgreSQL databases./span>/p>p classcode-line data-line2 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>One assumption is made that both database contains same sequence definitions, and the only differences are these code styleborder-radius: 4px; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px;>last_value/code> for these sequences./p>h3 classcode-line data-line4 dirauto idmethod-1---generate-ddl-on-source stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 1.25em; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Method 1 - Generate DDL on source/h3>ol classcode-line data-line6 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 0.7em; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>li classcode-line data-line6 dirauto styleposition: relative;>In order to retrieve code styleborder-radius: 4px; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px;>last_value/code> for different sequence, create following helper function./li>/ol>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line8 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>create/span> span classhljs-keyword stylecolor: blue;>or/span> replace span classhljs-keyword stylecolor: blue;>function/span> get_sequence_last_value (schema_name name, sequence_name name)span classhljs-keyword stylecolor: blue;>returns/span> span classhljs-keyword stylecolor: blue;>table/span> (sequence_value span classhljs-type stylecolor: #a31515;>bigint/span>)span classhljs-keyword stylecolor: blue;>language/span> span classhljs-string stylecolor: #a31515;>plpgsql/span>span classhljs-keyword stylecolor: blue;>AS/span>$$span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>return/span> query span classhljs-keyword stylecolor: blue;>execute/span> format (span classhljs-string stylecolor: #a31515;>select last_value from %I.%I/span>,schema_name,sequence_name);span classhljs-keyword stylecolor: blue;>end/span>;$$;/code>/pre>p classcode-line data-line20 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Test the function, make sure it works./p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line22 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> get_sequence_last_value(span classhljs-string stylecolor: #a31515;>public/span>,span classhljs-string stylecolor: #a31515;>s1/span>); get_sequence_last_valuespan classhljs-comment stylecolor: green; font-style: italic;>-------------------------/span> span classhljs-number stylecolor: green;>35/span>(span classhljs-number stylecolor: green;>1/span> span classhljs-type stylecolor: #a31515;>row/span>)/code>/pre>ol classcode-line data-line30 dirauto start2 stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 0.7em; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>li classcode-line data-line30 dirauto styleposition: relative;>Generate DDL scripts./li>/ol>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line32 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>span classhljs-keyword stylecolor: blue;>select/span> span classhljs-string stylecolor: #a31515;>alter sequence /span>span classhljs-operator>||/span>seq.schema_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>./span>span classhljs-operator>||/span>seq.sequence_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;> restart with /span>span classhljs-operator>||/span>v.sequence_valuespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>;/span>span classhljs-keyword stylecolor: blue;>from/span>(span classhljs-keyword stylecolor: blue;>select/span> s.nspname schema_name, c.relname sequence_name span classhljs-keyword stylecolor: blue;>from/span> pg_class c, pg_namespace s span classhljs-keyword stylecolor: blue;>where/span> c.relnamespacespan classhljs-operator>/span>s.oid span classhljs-keyword stylecolor: blue;>and/span> c.relkindspan classhljs-operator>/span>span classhljs-string stylecolor: #a31515;>S/span> span classhljs-keyword stylecolor: blue;>and/span> s.nspname span classhljs-keyword stylecolor: blue;>in/span> (span classhljs-string stylecolor: #a31515;>public/span>)) seq span classhljs-keyword stylecolor: blue;>join/span> span classhljs-keyword stylecolor: blue;>lateral/span> get_sequence_last_value(seq.schema_name,seq.sequence_name) vspan classhljs-keyword stylecolor: blue;>on/span> span classhljs-literal stylecolor: #a31515;>true/span>span classhljs-keyword stylecolor: blue;>order/span> span classhljs-keyword stylecolor: blue;>by/span> seq.schema_name,seq.sequence_name;/code>/pre>p classcode-line data-line44 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Sample output:/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line46 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>mytestspan classhljs-operator>/span># span classhljs-keyword stylecolor: blue;>select/span> span classhljs-string stylecolor: #a31515;>alter sequence /span>span classhljs-operator>||/span>seq.schema_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>./span>span classhljs-operator>||/span>seq.sequence_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;> restart with /span>span classhljs-operator>||/span>v.sequence_valuespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>;/span>mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>from/span>mytestspan classhljs-operator>-/span># (span classhljs-keyword stylecolor: blue;>select/span> s.nspname schema_name, c.relname sequence_namemytest(# span classhljs-keyword stylecolor: blue;>from/span> pg_class c, pg_namespace smytest(# span classhljs-keyword stylecolor: blue;>where/span> c.relnamespacespan classhljs-operator>/span>s.oidmytest(# span classhljs-keyword stylecolor: blue;>and/span> c.relkindspan classhljs-operator>/span>span classhljs-string stylecolor: #a31515;>S/span>mytest(# span classhljs-keyword stylecolor: blue;>and/span> s.nspname span classhljs-keyword stylecolor: blue;>in/span> (span classhljs-string stylecolor: #a31515;>public/span>)) seqmytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>join/span> span classhljs-keyword stylecolor: blue;>lateral/span> get_sequence_last_value(seq.schema_name,seq.sequence_name) vmytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>on/span> span classhljs-literal stylecolor: #a31515;>true/span>mytestspan classhljs-operator>-/span># span classhljs-keyword stylecolor: blue;>order/span> span classhljs-keyword stylecolor: blue;>by/span> seq.schema_name,seq.sequence_name; ?span classhljs-keyword stylecolor: blue;>column/span>?span classhljs-comment stylecolor: green; font-style: italic;>-------------------------------------------------------------/span> span classhljs-keyword stylecolor: blue;>alter/span> sequence public.s1 restart span classhljs-keyword stylecolor: blue;>with/span> span classhljs-number stylecolor: green;>35/span>; span classhljs-keyword stylecolor: blue;>alter/span> sequence public.s2 restart span classhljs-keyword stylecolor: blue;>with/span> span classhljs-number stylecolor: green;>28/span>; span classhljs-keyword stylecolor: blue;>alter/span> sequence public.sporting_event_id_seq restart span classhljs-keyword stylecolor: blue;>with/span> span classhljs-number stylecolor: green;>1/span>;(span classhljs-number stylecolor: green;>3/span> span classhljs-keyword stylecolor: blue;>rows/span>)/code>/pre>ol classcode-line data-line66 dirauto start3 stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 0.7em; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>li classcode-line data-line66 dirauto styleposition: relative;>Apply these DDLs to the target database/li>/ol>h3 classcode-line data-line68 dirauto idmethod-2---retrieve-sequence-value-via-dblink stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 1.25em; font-variant-ligatures: normal; line-height: 1.25; margin-bottom: 16px; margin-top: 24px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Method 2 - Reset sequence values via dblink/h3>p classcode-line data-line70 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>In below script, it create code styleborder-radius: 4px; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px;>dblink/code>, retrieve latest value from over the dblink and set the code styleborder-radius: 4px; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px;>restart/code> value for these sequences in the current database./p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line71 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>do$$span classhljs-keyword stylecolor: blue;>declare/span> seq_value span classhljs-type stylecolor: #a31515;>bigint/span>; rec_seq record; cur_seq span classhljs-keyword stylecolor: blue;>cursor/span> span classhljs-keyword stylecolor: blue;>for/span> span classhljs-keyword stylecolor: blue;>select/span> s.nspname schema_name, c.relname sequence_name span classhljs-keyword stylecolor: blue;>from/span> pg_class c, pg_namespace s span classhljs-keyword stylecolor: blue;>where/span> c.relnamespacespan classhljs-operator>/span>s.oid span classhljs-keyword stylecolor: blue;>and/span> c.relkindspan classhljs-operator>/span>span classhljs-string stylecolor: #a31515;>S/span> span classhljs-keyword stylecolor: blue;>and/span> s.nspname span classhljs-keyword stylecolor: blue;>in/span> (span classhljs-string stylecolor: #a31515;>public/span>);span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>execute/span> span classhljs-string stylecolor: #a31515;>SELECT dblink_connect($1,$2)/span> span classhljs-keyword stylecolor: blue;>using/span> span classhljs-string stylecolor: #a31515;>myconn/span>,span classhljs-string stylecolor: #a31515;>dbnamemytest/span>; exception span classhljs-keyword stylecolor: blue;>when/span> others span classhljs-keyword stylecolor: blue;>then/span> raise notice span classhljs-string stylecolor: #a31515;>Connection creation exception, safely ignore if subsequent code works/span>; span classhljs-keyword stylecolor: blue;>end/span>; span classhljs-keyword stylecolor: blue;>open/span> cur_seq; loop span classhljs-keyword stylecolor: blue;>fetch/span> cur_seq span classhljs-keyword stylecolor: blue;>into/span> rec_seq; exit span classhljs-keyword stylecolor: blue;>when/span> span classhljs-keyword stylecolor: blue;>not/span> found; raise notice span classhljs-string stylecolor: #a31515;>Processing: %/span>, rec_seq.schema_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>./span>span classhljs-operator>||/span>rec_seq.sequence_name; span classhljs-comment stylecolor: green; font-style: italic;>-- process for each sequence found on the target/span> span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>select/span> id span classhljs-keyword stylecolor: blue;>into/span> seq_value span classhljs-keyword stylecolor: blue;>from/span> dblink(span classhljs-string stylecolor: #a31515;>myconn/span>, span classhljs-string stylecolor: #a31515;>select last_value from /span>span classhljs-operator>||/span>rec_seq.schema_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>./span>span classhljs-operator>||/span>rec_seq.sequence_name) span classhljs-keyword stylecolor: blue;>as/span> p(id span classhljs-type stylecolor: #a31515;>int/span>); span classhljs-keyword stylecolor: blue;>begin/span> raise notice span classhljs-string stylecolor: #a31515;>alter sequence %.% restart with %/span>, rec_seq.schema_name,rec_seq.sequence_name,seq_value; span classhljs-keyword stylecolor: blue;>execute/span> format(span classhljs-string stylecolor: #a31515;>alter sequence %I.%I restart with %s/span>,rec_seq.schema_name,rec_seq.sequence_name,seq_value); exception span classhljs-keyword stylecolor: blue;>when/span> others span classhljs-keyword stylecolor: blue;>then/span> raise notice span classhljs-string stylecolor: #a31515;>Exception occurred to set sequence %/span>, rec_seq.schema_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>./span>span classhljs-operator>||/span>rec_seq.sequence_name; span classhljs-keyword stylecolor: blue;>end/span>; exception span classhljs-keyword stylecolor: blue;>when/span> others span classhljs-keyword stylecolor: blue;>then/span> raise notice span classhljs-string stylecolor: #a31515;>Exception occurred to fetch sequence %/span>, rec_seq.schema_namespan classhljs-operator>||/span>span classhljs-string stylecolor: #a31515;>./span>span classhljs-operator>||/span>rec_seq.sequence_name; span classhljs-keyword stylecolor: blue;>end/span>; span classhljs-keyword stylecolor: blue;>end/span> loop; span classhljs-keyword stylecolor: blue;>begin/span> span classhljs-keyword stylecolor: blue;>execute/span> span classhljs-string stylecolor: #a31515;>SELECT dblink_disconnect($1)/span> span classhljs-keyword stylecolor: blue;>using/span> span classhljs-string stylecolor: #a31515;>myconn/span>; exception span classhljs-keyword stylecolor: blue;>when/span> others span classhljs-keyword stylecolor: blue;>then/span> raise notice span classhljs-string stylecolor: #a31515;>Connection disconnect exception, safely ignore./span>; span classhljs-keyword stylecolor: blue;>end/span>; span classhljs-keyword stylecolor: blue;>end/span>;$$ span classhljs-keyword stylecolor: blue;>language/span> plpgsql;/code>/pre>p classcode-line data-line122 dirauto stylecolor: #3b3b3b; font-family: -apple-system, system-ui, "Segoe WPC", "Segoe UI", system-ui, Ubuntu, "Droid Sans", sans-serif; font-size: 14px; font-variant-ligatures: normal; margin-bottom: 16px; margin-top: 0px; orphans: 2; position: relative; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; widows: 2;>Sample output:/p>pre styleborder-radius: 3px; border: 1px solid var(--vscode-widget-border); color: #3b3b3b; font-size: 14px; font-variant-ligatures: normal; margin-top: 0px; orphans: 2; overflow: auto; padding: 16px; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-wrap: wrap; widows: 2;>code classcode-line language-sql data-line124 dirauto stylebackground: none; border-radius: 4px; display: inline-block; font-family: var(--vscode-editor-font-family, "SF Mono", Monaco, Menlo, Consolas, "Ubuntu Mono", "Liberation Mono", "DejaVu Sans Mono", "Courier New", monospace); font-size: 1em; line-height: 1.357em; padding: 1px 3px; position: relative; tab-size: 4;>NOTICE: Processing: public.sporting_event_id_seqNOTICE: span classhljs-keyword stylecolor: blue;>alter/span> sequence public.sporting_event_id_seq restart span classhljs-keyword stylecolor: blue;>with/span> span classhljs-number stylecolor: green;>1/span>NOTICE: Processing: public.s3NOTICE: Exception occurred span classhljs-keyword stylecolor: blue;>to/span> span classhljs-keyword stylecolor: blue;>fetch/span> sequence public.s3NOTICE: Processing: public.s1NOTICE: span classhljs-keyword stylecolor: blue;>alter/span> sequence public.s1 restart span classhljs-keyword stylecolor: blue;>with/span> span classhljs-number stylecolor: green;>35/span>NOTICE: Processing: public.s2NOTICE: span classhljs-keyword stylecolor: blue;>alter/span> sequence public.s2 restart span classhljs-keyword stylecolor: blue;>with/span> span classhljs-number stylecolor: green;>28/span>DOQuery returned successfully span classhljs-keyword stylecolor: blue;>in/span> span classhljs-number stylecolor: green;>87/span> msec./code>/pre>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-author vcard>Posted byspan classfn>Luo Donghua/span>/span>span classpost-timestamp>ata classtimestamp-link hrefhttps://www.dbaglobe.com/2024/02/how-to-keep-postgresql-sequences-value.html relbookmark titlepermanent link>abbr classpublished title2024-02-06T19:00:00+08:00>7:00 PM/abbr>/a>/span>span classpost-comment-link>a classcomment-link hrefhttps://www.dbaglobe.com/2024/02/how-to-keep-postgresql-sequences-value.html#comment-form onclick>0comments/a>/span>span classpost-icons>span classitem-control blog-admin pid-1645370588>a hrefhttps://www.blogger.com/post-edit.g?blogID8091710565846343105&postID55417943897235568&frompencil titleEdit Post>img alt classicon-action height18 srchttps://resources.blogblog.com/img/icon18_edit_allbkg.gif width18/>/a>/span>/span>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttps://www.dbaglobe.com/search/label/Postgresql reltag>Postgresql/a>/span>/div>div classpost-footer-line post-footer-line-3>span classpost-location>/span>/div>/div>/div>/div> /div>/div> /div>div classblog-pager idblog-pager>span idblog-pager-older-link>a classblog-pager-older-link hrefhttps://www.dbaglobe.com/search?updated-max2024-02-06T19:00:00%2B08:00&max-results7 idBlog1_blog-pager-older-link titleOlder Posts>Older Posts/a>/span>a classhome-link hrefhttps://www.dbaglobe.com/>Home/a>/div>div classclear>/div>div classblog-feeds>div classfeed-links>Subscribe to:a classfeed-link hrefhttps://www.dbaglobe.com/feeds/posts/default target_blank typeapplication/atom+xml>Posts (Atom)/a>/div>/div>/div>/div>/div>div idsidebar-wrapper>div classsidebar section idsidebar>div classwidget AdSense data-version1 idAdSense2>div classwidget-content>script async srchttps://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js>/script>!-- dbaglobe_sidebar_AdSense2_1x1_as -->ins classadsbygoogle styledisplay:block data-ad-clientca-pub-6105119525288020 data-ad-hostca-host-pub-1556223355139109 data-ad-host-channelL0001 data-ad-slot3551051091 data-ad-formatauto data-full-width-responsivetrue>/ins>script>(adsbygoogle window.adsbygoogle || ).push({});/script>div classclear>/div>/div>/div>div classwidget Text data-version1 idText1>h2 classtitle>Disclaimer/h2>div classwidget-content>span stylebackground-color: white; white-space: pre-wrap;font-family:, ,;font-size:15px;color:#14171a;>Posts are solely personal opinions on data management & new technologies./span>/div>div classclear>/div>/div>div classwidget Label data-version1 idLabel1>h2>Labels/h2>div classwidget-content list-label-widget-content>ul>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/AIX>AIX/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Analytics>Analytics/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Apache%20Cassandra>Apache Cassandra/a>span dirltr>(7)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Apache%20Hbase>Apache Hbase/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Apache%20Spark>Apache Spark/a>span dirltr>(24)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Atlas>Atlas/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/AWS>AWS/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Azure>Azure/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Banana>Banana/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/C%2B%2B>C++/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Cassandra>Cassandra/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Cloudera>Cloudera/a>span dirltr>(66)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Data%20Lake>Data Lake/a>span dirltr>(4)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/DB2>DB2/a>span dirltr>(5)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Elastic>Elastic/a>span dirltr>(5)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/EMC>EMC/a>span dirltr>(5)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Enterprise%20Manager>Enterprise Manager/a>span dirltr>(2)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/GoldenGate>GoldenGate/a>span dirltr>(4)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Greenplum>Greenplum/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Hadoop>Hadoop/a>span dirltr>(66)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Hive>Hive/a>span dirltr>(27)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Hortonworks>Hortonworks/a>span dirltr>(7)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/HPUX>HPUX/a>span dirltr>(2)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Impala>Impala/a>span dirltr>(7)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Kafka>Kafka/a>span dirltr>(5)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Kudu>Kudu/a>span dirltr>(3)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Linux>Linux/a>span dirltr>(77)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/MacOS>MacOS/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Microsoft%20SQL%20Server>Microsoft SQL Server/a>span dirltr>(85)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/MongoDB>MongoDB/a>span dirltr>(18)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/MsSQL>MsSQL/a>span dirltr>(12)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/MySQL>MySQL/a>span dirltr>(31)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Neo4j>Neo4j/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Oozie>Oozie/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Oracle>Oracle/a>span dirltr>(426)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Pandas>Pandas/a>span dirltr>(13)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Postgresql>Postgresql/a>span dirltr>(35)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Python>Python/a>span dirltr>(54)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/R>R/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/RDS>RDS/a>span dirltr>(6)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Redhat>Redhat/a>span dirltr>(5)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Solaris>Solaris/a>span dirltr>(18)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Spark>Spark/a>span dirltr>(14)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/TLS>TLS/a>span dirltr>(1)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/VirtualBox>VirtualBox/a>span dirltr>(3)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/WebLogic>WebLogic/a>span dirltr>(2)/span>/li>li>a dirltr hrefhttps://www.dbaglobe.com/search/label/Windows>Windows/a>span dirltr>(15)/span>/li>/ul>div classclear>/div>/div>/div>div classwidget BlogArchive data-version1 idBlogArchive1>h2>Blog Archive/h2>div classwidget-content>div idArchiveList>div idBlogArchive1_ArchiveList>ul classhierarchy>li classarchivedate expanded>a classtoggle hrefjavascript:void(0)>span classzippy toggle-open> ▼ /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2024/>2024/a>span classpost-count dirltr>(5)/span>ul classhierarchy>li classarchivedate expanded>a classtoggle hrefjavascript:void(0)>span classzippy toggle-open> ▼ /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2024/07/>July/a>span classpost-count dirltr>(1)/span>ul classposts>li>a hrefhttps://www.dbaglobe.com/2024/07/performance-validation-for-uuidv7.html>Performance validation for UUIDv7 implemented usin.../a>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2024/05/>May/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2024/02/>February/a>span classpost-count dirltr>(3)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/>2023/a>span classpost-count dirltr>(18)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/10/>October/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/09/>September/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/08/>August/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/06/>June/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/04/>April/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/03/>March/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2023/01/>January/a>span classpost-count dirltr>(3)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/>2022/a>span classpost-count dirltr>(42)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/11/>November/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/10/>October/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/08/>August/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/07/>July/a>span classpost-count dirltr>(9)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/06/>June/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/05/>May/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/04/>April/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/03/>March/a>span classpost-count dirltr>(12)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/02/>February/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2022/01/>January/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/>2021/a>span classpost-count dirltr>(45)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/12/>December/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/11/>November/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/10/>October/a>span classpost-count dirltr>(11)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/09/>September/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/08/>August/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/05/>May/a>span classpost-count dirltr>(7)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/04/>April/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2021/01/>January/a>span classpost-count dirltr>(7)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/>2020/a>span classpost-count dirltr>(39)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/12/>December/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/10/>October/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/09/>September/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/08/>August/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/07/>July/a>span classpost-count dirltr>(7)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/06/>June/a>span classpost-count dirltr>(6)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/05/>May/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/04/>April/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2020/03/>March/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/>2019/a>span classpost-count dirltr>(32)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/11/>November/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/10/>October/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/08/>August/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/06/>June/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/05/>May/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/04/>April/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/03/>March/a>span classpost-count dirltr>(19)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2019/02/>February/a>span classpost-count dirltr>(3)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/>2018/a>span classpost-count dirltr>(80)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/12/>December/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/10/>October/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/09/>September/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/08/>August/a>span classpost-count dirltr>(7)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/07/>July/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/06/>June/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/05/>May/a>span classpost-count dirltr>(12)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/04/>April/a>span classpost-count dirltr>(15)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/03/>March/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/02/>February/a>span classpost-count dirltr>(14)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2018/01/>January/a>span classpost-count dirltr>(13)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/>2017/a>span classpost-count dirltr>(61)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/12/>December/a>span classpost-count dirltr>(35)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/11/>November/a>span classpost-count dirltr>(9)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/10/>October/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/09/>September/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/08/>August/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/07/>July/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/06/>June/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2017/05/>May/a>span classpost-count dirltr>(2)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/>2016/a>span classpost-count dirltr>(41)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/12/>December/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/11/>November/a>span classpost-count dirltr>(14)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/10/>October/a>span classpost-count dirltr>(9)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/07/>July/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/06/>June/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/05/>May/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/03/>March/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2016/02/>February/a>span classpost-count dirltr>(3)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/>2015/a>span classpost-count dirltr>(90)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/11/>November/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/10/>October/a>span classpost-count dirltr>(15)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/09/>September/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/08/>August/a>span classpost-count dirltr>(14)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/07/>July/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/06/>June/a>span classpost-count dirltr>(15)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/05/>May/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/04/>April/a>span classpost-count dirltr>(13)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/03/>March/a>span classpost-count dirltr>(12)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2015/01/>January/a>span classpost-count dirltr>(2)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/>2014/a>span classpost-count dirltr>(105)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/12/>December/a>span classpost-count dirltr>(14)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/11/>November/a>span classpost-count dirltr>(7)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/10/>October/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/09/>September/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/08/>August/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/07/>July/a>span classpost-count dirltr>(21)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/06/>June/a>span classpost-count dirltr>(23)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/05/>May/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/04/>April/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/02/>February/a>span classpost-count dirltr>(15)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2014/01/>January/a>span classpost-count dirltr>(2)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2013/>2013/a>span classpost-count dirltr>(45)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2013/12/>December/a>span classpost-count dirltr>(24)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2013/11/>November/a>span classpost-count dirltr>(13)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2013/08/>August/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2013/05/>May/a>span classpost-count dirltr>(6)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2012/>2012/a>span classpost-count dirltr>(11)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2012/12/>December/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2012/08/>August/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2012/05/>May/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2012/04/>April/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2012/01/>January/a>span classpost-count dirltr>(2)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/>2011/a>span classpost-count dirltr>(101)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/12/>December/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/11/>November/a>span classpost-count dirltr>(6)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/10/>October/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/09/>September/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/07/>July/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/06/>June/a>span classpost-count dirltr>(13)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/05/>May/a>span classpost-count dirltr>(26)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/04/>April/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/03/>March/a>span classpost-count dirltr>(3)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/02/>February/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2011/01/>January/a>span classpost-count dirltr>(23)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/>2010/a>span classpost-count dirltr>(67)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/12/>December/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/11/>November/a>span classpost-count dirltr>(15)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/10/>October/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/09/>September/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/08/>August/a>span classpost-count dirltr>(10)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/06/>June/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/05/>May/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/03/>March/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/02/>February/a>span classpost-count dirltr>(16)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2010/01/>January/a>span classpost-count dirltr>(5)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2009/>2009/a>span classpost-count dirltr>(65)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2009/12/>December/a>span classpost-count dirltr>(14)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2009/10/>October/a>span classpost-count dirltr>(8)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2009/09/>September/a>span classpost-count dirltr>(37)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2009/08/>August/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttps://www.dbaglobe.com/2009/07/>July/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>/div>/div>div classclear>/div>/div>/div>div classwidget BlogSearch data-version1 idBlogSearch1>h2 classtitle>Search This Website/h2>div classwidget-content>div idBlogSearch1_form>form actionhttps://www.dbaglobe.com/search classgsc-search-box target_top>table cellpadding0 cellspacing0 classgsc-search-box>tbody>tr>td classgsc-input>input autocompleteoff classgsc-input nameq size10 titlesearch typetext value/>/td>td classgsc-search-button>input classgsc-search-button titlesearch typesubmit valueSearch/>/td>/tr>/tbody>/table>/form>/div>/div>div classclear>/div>/div>div classwidget HTML data-version1 idHTML2>h2 classtitle>Tweets by Me/h2>div classwidget-content>a classtwitter-timeline data-langen hrefhttps://twitter.com/luodonghua>Tweets by luodonghua/a> script async src//platform.twitter.com/widgets.js charsetutf-8>/script>/div>div classclear>/div>/div>/div>/div>!-- spacer for skins that want sidebar and main to be the same height-->div classclear> /div>/div>!-- end content-wrapper -->div idfooter-wrapper>div classfooter section idfooter>div classwidget HTML data-version1 idHTML1>div classwidget-content>script typetext/javascript>var gaJsHost ((https: document.location.protocol) ? https://ssl. : http://www.);document.write(unescape(%3Cscript src + gaJsHost + google-analytics.com/ga.js typetext/javascript%3E%3C/script%3E));/script>script typetext/javascript>try {var pageTracker _gat._getTracker(UA-2142687-5);pageTracker._trackPageview();} catch(err) {}/script>/div>div classclear>/div>/div>/div>/div>/div>/div>!-- end outer-wrapper -->script typetext/javascript srchttps://www.blogger.com/static/v1/widgets/2061172683-widgets.js>/script>script typetext/javascript>window__wavt AOuZoY7FV6qdV_qj6jVXjYlFNu5Owgs6Jw:1722904624957;_WidgetManager._Init(//www.blogger.com/rearrange?blogID\x3d8091710565846343105,//www.dbaglobe.com/,8091710565846343105);_WidgetManager._SetDataContext({name: blog, data: {blogId: 8091710565846343105, title: Donghua\x27s Blog - DBAGlobe, url: https://www.dbaglobe.com/, canonicalUrl: https://www.dbaglobe.com/, homepageUrl: https://www.dbaglobe.com/, searchUrl: https://www.dbaglobe.com/search, canonicalHomepageUrl: https://www.dbaglobe.com/, blogspotFaviconUrl: https://www.dbaglobe.com/favicon.ico, bloggerUrl: https://www.blogger.com, hasCustomDomain: true, httpsEnabled: true, enabledCommentProfileImages: true, gPlusViewType: FILTERED_POSTMOD, adultContent: false, analyticsAccountNumber: , encoding: UTF-8, locale: en, localeUnderscoreDelimited: en, languageDirection: ltr, isPrivate: false, isMobile: false, isMobileRequest: false, mobileClass: , isPrivateBlog: false, isDynamicViewsAvailable: true, feedLinks: \x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Donghua\x26#39;s Blog - DBAGlobe - Atom\x22 href\x3d\x22https://www.dbaglobe.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Donghua\x26#39;s Blog - DBAGlobe - RSS\x22 href\x3d\x22https://www.dbaglobe.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Donghua\x26#39;s Blog - DBAGlobe - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/8091710565846343105/posts/default\x22 /\x3e\n, meTag: \x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/09892213541160033846\x22 /\x3e\n, adsenseClientId: ca-pub-6105119525288020, adsenseHostId: ca-host-pub-1556223355139109, adsenseHasAds: true, adsenseAutoAds: false, boqCommentIframeForm: true, loginRedirectParam: , view: , dynamicViewsCommentsSrc: //www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js, dynamicViewsScriptSrc: //www.blogblog.com/dynamicviews/667321849f11f3a9, plusOneApiSrc: https://apis.google.com/js/platform.js, disableGComments: true, interstitialAccepted: false, sharing: {platforms: {name: Get link, key: link, shareMessage: Get link, target: }, {name: Facebook, key: facebook, shareMessage: Share to Facebook, target: facebook}, {name: BlogThis!, key: blogThis, shareMessage: BlogThis!, target: blog}, {name: Twitter, key: twitter, shareMessage: Share to Twitter, target: twitter}, {name: Pinterest, key: pinterest, shareMessage: Share to Pinterest, target: pinterest}, {name: Email, key: email, shareMessage: Email, target: email}, disableGooglePlus: true, googlePlusShareButtonWidth: 0, googlePlusBootstrap: \x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e}, hasCustomJumpLinkMessage: false, jumpLinkMessage: Read more, pageType: index, pageName: , pageTitle: Donghua\x27s Blog - DBAGlobe, metaDescription: A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.}}, {name: features, data: {}}, {name: messages, data: {edit: Edit, linkCopiedToClipboard: Link copied to clipboard!, ok: Ok, postLink: Post Link}}, {name: template, data: {name: custom, localizedName: Custom, isResponsive: false, isAlternateRendering: false, isCustom: true}}, {name: view, data: {classic: {name: classic, url: ?view\x3dclassic}, flipcard: {name: flipcard, url: ?view\x3dflipcard}, magazine: {name: magazine, url: ?view\x3dmagazine}, mosaic: {name: mosaic, url: ?view\x3dmosaic}, sidebar: {name: sidebar, url: ?view\x3dsidebar}, snapshot: {name: snapshot, url: ?view\x3dsnapshot}, timeslide: {name: timeslide, url: ?view\x3dtimeslide}, isMobile: false, title: Donghua\x27s Blog - DBAGlobe, description: A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc., url: https://www.dbaglobe.com/, type: feed, isSingleItem: false, isMultipleItems: true, isError: false, isPage: false, isPost: false, isHomepage: true, isArchive: false, isLabelSearch: false}});_WidgetManager._RegisterWidget(_NavbarView, new _WidgetInfo(Navbar1, navbar, document.getElementById(Navbar1), {}, displayModeFull));_WidgetManager._RegisterWidget(_HeaderView, new _WidgetInfo(Header1, header, document.getElementById(Header1), {}, displayModeFull));_WidgetManager._RegisterWidget(_BlogView, new _WidgetInfo(Blog1, main, document.getElementById(Blog1), {cmtInteractionsEnabled: false, lightboxEnabled: true, lightboxModuleUrl: https://www.blogger.com/static/v1/jsbin/3189325340-lbx.js, lightboxCssUrl: https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css}, displayModeFull));_WidgetManager._RegisterWidget(_AdSenseView, new _WidgetInfo(AdSense2, sidebar, document.getElementById(AdSense2), {}, displayModeFull));_WidgetManager._RegisterWidget(_TextView, new _WidgetInfo(Text1, sidebar, document.getElementById(Text1), {}, displayModeFull));_WidgetManager._RegisterWidget(_LabelView, new _WidgetInfo(Label1, sidebar, document.getElementById(Label1), {}, displayModeFull));_WidgetManager._RegisterWidget(_BlogArchiveView, new _WidgetInfo(BlogArchive1, sidebar, document.getElementById(BlogArchive1), {languageDirection: ltr, loadingMessage: Loading\x26hellip;}, displayModeFull));_WidgetManager._RegisterWidget(_BlogSearchView, new _WidgetInfo(BlogSearch1, sidebar, document.getElementById(BlogSearch1), {}, displayModeFull));_WidgetManager._RegisterWidget(_HTMLView, new _WidgetInfo(HTML2, sidebar, document.getElementById(HTML2), {}, displayModeFull));_WidgetManager._RegisterWidget(_HTMLView, new _WidgetInfo(HTML1, footer, document.getElementById(HTML1), {}, displayModeFull));/script>/body>/html>
View on OTX
|
View on ThreatMiner
Please enable JavaScript to view the
comments powered by Disqus.
Data with thanks to
AlienVault OTX
,
VirusTotal
,
Malwr
and
others
. [
Sitemap
]