{"id":656,"date":"2019-05-09T12:56:08","date_gmt":"2019-05-09T04:56:08","guid":{"rendered":"https:\/\/cleardatascience.com\/?page_id=656"},"modified":"2019-06-06T18:53:33","modified_gmt":"2019-06-06T10:53:33","slug":"postgresql","status":"publish","type":"page","link":"https:\/\/cleardatascience.com\/en\/postgresql\/","title":{"rendered":"PostgreSQL"},"content":{"rendered":"

\"\"<\/h4>\n

The World’s Most Advanced Open Source Relational Database<\/span><\/h4>\n
\n

Clear Data Science Limited (CDS)<\/span> is a data science company familiar with different relational databases for data warehousing, NoSQL databases on IoT and Hadoop on unstructured data. With our expertise in data management and data architecture, we are confidence to build all types of data platform with our clients.<\/h3>\n
\n
\n
<\/div>\n
\n

About PostgreSQL<\/strong><\/h3>\n<\/div>\n
<\/div>\n
\n

PostgreSQL is an open-source relational database management system emphasizing extensibility and standards compliance. It can handle workloads ranging from single-machine applications to Web services or data warehousing with many concurrent users. This database engine can be compared to any enterprise class database engine without significant license investment.<\/p>\n<\/div>\n

<\/div>\n
<\/div>\n<\/div>\n
\n
\n
<\/div>\n
\n

Enterprise-Class Features<\/strong><\/h3>\n<\/div>\n
<\/div>\n
\n
    \n
  • Multi-version concurrency control (MVCC)<\/li>\n
  • \u00a0Tablespaces<\/li>\n
  • \u00a0Point-in-time recovery<\/li>\n
  • \u00a0Sophisticated locking mechanism<\/li>\n
  • \u00a0Table inheritance<\/li>\n
  • \u00a0User-defined types<\/li>\n
  • \u00a0Foreign key referential integrity<\/li>\n
  • \u00a0Views, rules, subquery<\/li>\n
  • \u00a0Nested Transactions (savepoints)<\/li>\n
  • \u00a0Asynchronous replication<\/li>\n
  • \u00a0Clustering, Load-balancing<\/li>\n
  • \u00a0High Availability (HA)<\/li>\n
  • \u00a0Multi-platform support (AIX, HP\/UX, Solaris, FreeBSD, Mac OS-X, Linux (all distros), Windows, etc.)<\/li>\n<\/ul>\n<\/div>\n
    <\/div>\n
    <\/div>\n<\/div>\n
    \n
    \n
    <\/div>\n
    \n

    Professional Service<\/strong><\/h3>\n<\/div>\n
    <\/div>\n
    \n

    A number of database experts are available in handling different RDBMS including EnterpriseDB PostgreSQL, MariaDB, MySQL, IBM DB2, IBM Informix, Microsoft SQL Server, Oracle, Sybase ASE and Sybase IQ.<\/p>\n

    Installation and Configuration<\/strong><\/p>\n

    Help clients to install and configure PostgreSQL environment including clusters, load-balancing and high availability in both on-premises and cloud environment with partners. All installation and configuration is based on the best practice suggested in the PostgreSQL official website.<\/p>\n

    Oracle Replacement<\/strong><\/p>\n

    Help clients to build data warehouse with the power of open source PostgreSQL. Well experienced to migrate Oracle Enterprise database to open source platform including the migration of Oracle with Schema conversion and Oracle PL\/SQL to PostgreSQL PL\/pgSQL migration.<\/p>\n

    Database Performance Tuning<\/strong><\/p>\n

    To tune a database performance, it is basically related to the optimization of the usage of available system resource such as CPU, Memory and I\/O. In order to enhance the performances, there are a number of activities being carried and they are:<\/p>\n

      \n
    • Analyze PostgreSQL for system configuration and usage information<\/li>\n
    • Update Database parameter tuning<\/li>\n
    • Rewrite \/ tune slow SQL statements<\/li>\n
    • Reduce lock waiting time by detailed investigation<\/li>\n<\/ul>\n

      Training Service<\/strong><\/p>\n

      We would like to share our experiences on database management including on different usages \u2013 OLTP and OLAP. There are different training classes available:<\/p>\n

        \n
      • PostgreSQL Fundamental<\/li>\n
      • PostgreSQL Administration & Performance Tuning<\/li>\n
      • PostgreSQL Replication & Recovery<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n
        <\/div>\n<\/div>\n

         <\/p>\n","protected":false},"excerpt":{"rendered":"

        The World’s Most Advanced Open Source Relational Database Clear Data Science Limited (CDS) is a data science company familiar with […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/fullwidth.php","meta":{"_acf_changed":false,"nf_dc_page":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-656","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nPostgreSQL - Clear Data Science Limited<\/title>\n<meta name=\"description\" content=\"We are providing technical support on the most advanced open source relational database - POSTGRESQL. PostgreSQL includes lots of Enterprise class features.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cleardatascience.com\/en\/postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL - Clear Data Science Limited\" \/>\n<meta property=\"og:description\" content=\"We are providing technical support on the most advanced open source relational database - POSTGRESQL. PostgreSQL includes lots of Enterprise class features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cleardatascience.com\/en\/postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Clear Data Science Limited\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cleardatasciencelimited\/\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-06T10:53:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/05\/postgresql_logo.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/\",\"name\":\"PostgreSQL - Clear Data Science Limited\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/postgresql_logo.png\",\"datePublished\":\"2019-05-09T04:56:08+00:00\",\"dateModified\":\"2019-06-06T10:53:33+00:00\",\"description\":\"We are providing technical support on the most advanced open source relational database - POSTGRESQL. PostgreSQL includes lots of Enterprise class features.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/postgresql_logo.png\",\"contentUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/postgresql_logo.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/postgresql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cleardatascience.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#website\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/\",\"name\":\"Clear Data Science Limited\",\"description\":\"Clear Data Clear Picture\",\"publisher\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#organization\",\"name\":\"Clear Data Science Limited\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/CDS-Logo-small-h02.png\",\"contentUrl\":\"https:\\\/\\\/cleardatascience.com\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/CDS-Logo-small-h02.png\",\"width\":165,\"height\":45,\"caption\":\"Clear Data Science Limited\"},\"image\":{\"@id\":\"https:\\\/\\\/cleardatascience.com\\\/zh-hant\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/cleardatasciencelimited\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/16194855\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCS3jQw-3EZvmWkLr8ZyDHFw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL - Clear Data Science Limited","description":"We are providing technical support on the most advanced open source relational database - POSTGRESQL. PostgreSQL includes lots of Enterprise class features.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cleardatascience.com\/en\/postgresql\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL - Clear Data Science Limited","og_description":"We are providing technical support on the most advanced open source relational database - POSTGRESQL. PostgreSQL includes lots of Enterprise class features.","og_url":"https:\/\/cleardatascience.com\/en\/postgresql\/","og_site_name":"Clear Data Science Limited","article_publisher":"https:\/\/www.facebook.com\/cleardatasciencelimited\/","article_modified_time":"2019-06-06T10:53:33+00:00","og_image":[{"url":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/05\/postgresql_logo.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cleardatascience.com\/en\/postgresql\/","url":"https:\/\/cleardatascience.com\/en\/postgresql\/","name":"PostgreSQL - Clear Data Science Limited","isPartOf":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cleardatascience.com\/en\/postgresql\/#primaryimage"},"image":{"@id":"https:\/\/cleardatascience.com\/en\/postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/05\/postgresql_logo.png","datePublished":"2019-05-09T04:56:08+00:00","dateModified":"2019-06-06T10:53:33+00:00","description":"We are providing technical support on the most advanced open source relational database - POSTGRESQL. PostgreSQL includes lots of Enterprise class features.","breadcrumb":{"@id":"https:\/\/cleardatascience.com\/en\/postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cleardatascience.com\/en\/postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cleardatascience.com\/en\/postgresql\/#primaryimage","url":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/05\/postgresql_logo.png","contentUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/05\/postgresql_logo.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cleardatascience.com\/en\/postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cleardatascience.com\/en\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/cleardatascience.com\/zh-hant\/#website","url":"https:\/\/cleardatascience.com\/zh-hant\/","name":"Clear Data Science Limited","description":"Clear Data Clear Picture","publisher":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cleardatascience.com\/zh-hant\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cleardatascience.com\/zh-hant\/#organization","name":"Clear Data Science Limited","url":"https:\/\/cleardatascience.com\/zh-hant\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cleardatascience.com\/zh-hant\/#\/schema\/logo\/image\/","url":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/03\/CDS-Logo-small-h02.png","contentUrl":"https:\/\/cleardatascience.com\/wp-content\/uploads\/2019\/03\/CDS-Logo-small-h02.png","width":165,"height":45,"caption":"Clear Data Science Limited"},"image":{"@id":"https:\/\/cleardatascience.com\/zh-hant\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/cleardatasciencelimited\/","https:\/\/www.linkedin.com\/company\/16194855","https:\/\/www.youtube.com\/channel\/UCS3jQw-3EZvmWkLr8ZyDHFw"]}]}},"_links":{"self":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/pages\/656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/comments?post=656"}],"version-history":[{"count":5,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/pages\/656\/revisions"}],"predecessor-version":[{"id":857,"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/pages\/656\/revisions\/857"}],"wp:attachment":[{"href":"https:\/\/cleardatascience.com\/en\/wp-json\/wp\/v2\/media?parent=656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}