Implementation of Oracle Compatibility Function through orafunc in Green Plum Cluster

oracle data migration to Greenplum has a difficult problem, that is, many stored procedures called storage functions, one by one is too troublesome to change, so if you want to migrate smoothly, one way to compare is to implement functions with the same name and function in greenplum. 1. See if the orafunc plug-in has been installed ...

Posted on Sat, 29 Jun 2019 18:24:01 -0700 by Walle

Two implementations of Greenplum aggregation function: HashAggregate and GroupAggregate

Postgresql/Greenplum data base There are two ways to implement aggregation functions: HashAggregate and GroupAggregate. We now analyze the differences between the two aggregations and their application scenarios through a simplest sql.       select count(1) from pg_class group by oid; 1. Comparisons of two implementation algorithms: Ha ...

Posted on Sun, 09 Jun 2019 16:30:01 -0700 by hagman

Understanding the Construction of GiST Index from Spatial Perspective

Label PostgreSQL, GIS, PostGIS, Greenplum, Spatial Retrieval, GiST, B-Tree, Gehash background What are the results of GiST indexing that can support spatial retrieval? This article is an addition to the following two documents: Greenplum Space (GIS) Data Retrieval B-Tree & GiST Index Practice - Aliyun HybridDB for PostgreSQL Best Practic ...

Posted on Thu, 30 May 2019 13:48:28 -0700 by stylefrog

Greenplum 6 has been merged into PostgreSQL version 9.3 - 8 times read, 195 times update, delete, and a lot of new PG features over the previous generation of GP

Label PostgreSQL, Greenplum, 6, gin, asynchronous transactions background Greenplum 6 has been merged into PostgreSQL version 9.3 - with 5 performance improvements: 8 times read, 195 times update and delete - and a large number of new PG features, as detailed in PostgreSQL release notes https://www.postgresql.org/docs/11/static/release.html ...

Posted on Sat, 18 May 2019 10:47:13 -0700 by rokchik

Code Dry | Line Storage, Column Storage Heap Table, AO Table Performance Comparison - Aliyun HDB for PostgreSQL Best Practice

This article is from the Aliyun-Yunqi community, click on the original article Here. Label PostgreSQL, GIS, PostGIS, Greenplum, Spatial Retrieval, GiST, B-Tree, Gehash background Principles and Choices of Greenplum Row, Column, Heap and AO Tables The above documents describe in detail the principles of row storage, colum ...

Posted on Sat, 09 Feb 2019 00:15:17 -0800 by tabatsoy

Installation of Greenplum-CC-web Monitoring System

Article directory Summary download Pre-installation preparation Install the gpperfmon database and create passwords for gpmon users clear shutdown and startup Check for success Start and install gpcc Generate installation directory Grant authority Distribution of installation packages to all child nodes Initialize gpcc Lo ...

Posted on Fri, 01 Feb 2019 14:57:15 -0800 by pages

Aliyun HybridDB for PG Practice - Principle and Selection of Row Storage, Column Storage, Stack Table and AO Table

Label PostgreSQL, Greenplum, Vector Computing, Row Storage, Column Storage, AO Table background Greenplum supports row and column storage, heap tables and AO tables. What are the differences between them and how to choose them? Principles of row and column 1. Line storage, organized in the form of behavior storage, a line is a tuple, there ...

Posted on Tue, 01 Jan 2019 19:36:09 -0800 by kusarigama

How to Detect and Clean up Greenplum Waste-Aliyun HybridDB for PG Best Practice

Label PostgreSQL , Greenplum , HDB for PG background Greenplum supports data deletion and update concurrency and rollback through multiple versions. When deleting data (using DELETE deletion), the record header xmax value is marked. When deleting a record, mark the head of the record and insert a new version. This can lead to a problem where ...

Posted on Sat, 22 Dec 2018 19:09:10 -0800 by ternto333

Selection and optimization of spatial index (GiST, BRIN, R-Tree) - Aliyun RDS PostgreSQL Best Practice

Label PostgreSQL, Greenplum, PostGIS, GiST, R-Tree, BRIN, Relevance, Grid, BOX, K-Mean background Search requirements for spatial data usually include: 1. Plane, three-dimensional and multi-dimensional objects intersect, disjoint and adjacent in geometry. 2. The orientation judgment of plane, three-dimensional and multi-dimensional objects ( ...

Posted on Fri, 21 Dec 2018 19:06:06 -0800 by r4r4

Performance comparison of row, column, heap and AO tables - Aliyun HDB for PostgreSQL best practices

Label PostgreSQL, GIS, PostGIS, Greenplum, Spatial Retrieval, GiST, B-Tree, Gehash background Principles and Choices of Greenplum Row, Column, Heap and AO Tables The above documents describe in detail the principles of row storage, column storage, heap table, AO table and the basis for selection. "A Simple Algorithms Can Help Internet o ...

Posted on Thu, 13 Dec 2018 19:27:21 -0800 by alex2046