GreenPlum's events II: GreenPlum starts reporting errors

Labels (space delimited): GreenPlum In the process of configuring GreenPlum, you need to pay attention to the following points: Find the installation package Installation dependency, Gun version needs attention Detailed installation procedure reference Greenplum installation introduction I am a computer virtual machine insta ...

Posted on Sun, 10 Nov 2019 14:42:13 -0500 by antisback

Backup and Recovery of Greenplum

11. Backup and Recovery This chapter describes backup and recovery of database and user data in GPDB system. GP recommends backing up the database regularly. Backup can be used to restore and rebuild the GPDB system in case of system failure or data corruption. In addition, you can use backup to migrate GPDB data from one system to another. Pa ...

Posted on Sat, 22 Jun 2019 14:37:45 -0400 by lrsdsout

Deepgreen & Greenplum DBA White Popularization Course (General Question Answer)

If you want to be a qualified database administrator, you should first have solid basic knowledge and problem-solving ability. Referring to Pivotal's official FAQ, this article answers some common questions that are often encountered in the use and management of Deepgreen & Greenplum. I hope it will be helpful to you. If you have more quest ...

Posted on Mon, 17 Jun 2019 21:02:58 -0400 by girlzz

Using SQL to Play Data Mining MADlib (1) - Installation

Introduction to MADlibMADlib is an open source machine learning library cooperated by Pivotal and the University of Berkeley. It provides precise data parallel implementation, statistics and machine learning methods to analyze structured and unstructured data. The main purpose is to expand the analytical capability of the database, which can be ...

Posted on Mon, 17 Jun 2019 20:57:48 -0400 by djg_uk

Deepgreen & Greenplum DBA Small White Popularization Lesson Two (Management Question Answer)

If you want to be a qualified database administrator, you must first have solid basic knowledge and problem handling ability.Referring to Pivotal's official FAQ, this paper provides ideas/answers to common problems encountered in the management of Deepgreen & Greenplum.I hope it will help you. If you have more questions to share with your ...

Posted on Mon, 17 Jun 2019 13:21:50 -0400 by nickman013

Parsing the postmaster.opts and postmaster.pid content of Greenplum

This document parses the contents of postmaster.opts and postmaster.pid files under the Greenplum directory, which are slightly different from PostgreSQL.Let's look at an example of a Master node: [root@cdha ~]# cd /data/master/gpseg-1/ [root@cdha gpseg-1]# ll total 136 drwx------ 8 gpadmin gpadmin  4096 Jun 26 16:44 base drwx------ 2 gpadmin ...

Posted on Thu, 14 Feb 2019 03:15:19 -0500 by bb_sarkar

PostgreSQL vs Greenplum Hash outer join (choice of hash table)

Label PostgreSQL , Greenplum , hash outer join , hash table background Hash JOIN is a better way to speed up data analysis, large table JOIN and multi-table JOIN. hash join scans one of the tables (including fields that need to be output) and generates a hash table based on the JOIN column. Then scan another table. Introduction to hash joi ...

Posted on Fri, 08 Feb 2019 21:09:19 -0500 by bios

greenplum 5.7 + create table + insert into

os: centos 7.4 gp: gpdb-5.7.0 Three machines Noe1 is master host Noe2 and Noe3 are segment host psql login node 1 master $ psql -d peiybdb peiybdb=# select current_database(); current_database ------------------ peiybdb (1 row) create table tmp_t0( c1 varchar(100), c2 varchar(100), c3 varchar(100) ); NOTICE: Table ...

Posted on Thu, 07 Feb 2019 07:45:17 -0500 by dirgeshp

The Method of Automatically Establishing Correct Index (btree,hash,gin,gist,sp-gist,brin,bitmap...)

Label PostgreSQL, index interface, automatic index creation, automatic index selection interface, (btree,hash,bitmap,gin,gist,sp-gist,brin,rum,bloom,zoomdb) background PostgreSQL index interface is open, supporting btree,hash,bitmap,gin,gist,sp-gist,brin,rum,bloom,zoomdb and other index interfaces. Therefore, different data types have differ ...

Posted on Mon, 07 Jan 2019 14:33:10 -0500 by websmoken

Audio View (Pan Content) Web Site Perspective Analysis DB Design - Best Practices for PostgreSQL by RDS, HybridDB

Label PostgreSQL, User Perspective, Device Perspective, Circle, Label, Video Website, Youku, Potato, Himalaya background In daily life, people use the most content websites except social networking websites and shopping websites. It is estimated that they are audio, video and graphic information websites. Video websites have penetrated into ...

Posted on Mon, 07 Jan 2019 04:03:10 -0500 by rvdb86