Shulou(Shulou.com)06/01 Report--

This article shows you how to use PostgreSQL in HybridDB. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

HybridDB for PostgreSQL is developed based on the Greenplum Database open source database project. After being extended by Aliyun, it has the following features:

Compatible with Greenplum, users can directly use all the tools that support Greenplum.

Unique MetaScan and SortKey technologies greatly improve performance.

Support OSS storage, JSON data type, HyperLogLog estimation analysis and other functional features.

Provides flexible hybrid parsing capabilities by conforming to SQL 2008 standard query syntax and OLAP parsing aggregate functions.

Support row storage and column storage mixed mode, superior analysis performance.

Support data compression technology, low storage cost.

Provide online expansion, performance monitoring and other services, users no longer need to carry out complex large-scale MPP cluster operation and management work, so that DBA, developers and data analysts only need to focus on how to improve enterprise productivity and create core value through SQL.

Basic functions:

It has the core function of Geenplum Database. For more information, please see the documentation.

Support unique MetaScan and SortKey technologies.

Support for ORCA optimizer.

Support for distributed stored procedure writing through procedure languages PL/pgSQL and PL/Java.

PostGIS, MADlib, fuzzystrmatch, orafunc, pgcrypto, intarray and other plug-ins are supported (need to be created using the CREATE EXTENSION command).

Support the use of OSS_EXT plug-ins to read or write data from Ali Cloud object Storage OSS (Object Storage Service) to OSS, and support gzip compression to significantly save external table storage costs.

JSON data types and HyperLogLog types are supported (to be created using the CREATE EXTENSION command).

Functional limitations:

For core functional limitations, see the documentation.

Permission restrictions: the initial user of HybridDB for PostgreSQL (called "root user") has permission to create a database (CREATEDB) and create user (CREATEROLE), but does not have superuser (SUPERUSER) privileges, so it cannot perform operations that require superuser privileges. For example, execute file functions such as pg_ls_dir. However, the root user has the right to view and modify the data of all other non-superusers, Kill the connections of other non-superusers, and so on.

The PL/R and PL/Java plug-ins are not supported.

PL/Python plug-in creation is supported, but function creation using the PL/Python language is not supported.

The gpfdist tool is not supported.

The MapReduce interface, gphdfs storage interface, and local external tables are not supported.

Automatic backup and recovery features are not supported for the time being. HybridDB saves two copies of data, and users can also back up their own data using the pg_dump tool. 、

The above is how to use PostgreSQL in HybridDB. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.