PostgreSQL Securities Industry Database Requirement Analysis and Application

Label PostgreSQL, Securities, Time Series Data, JSON, HSTORE, Array, range Index, BRIN Block Index, Time Sharing Trend, Linear Regression, MADlib, Machine Learning background The securities industry produces more data, reading and writing is very frequent. Take stock trading for example, there are thousands of shares in total.There are abou ...

Posted on Mon, 08 Jul 2019 09:15:14 -0700 by WolfRage

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

Spatial Composite Index Accelerates Spatial Search

Label PostgreSQL, PostGIS, Composite Index, btree_gist, Shared Bicycle background With the popularity of mobile Internet, spatial data has become the standard of most enterprise data, such as travel, express, etc. Usually, the query of data will have location distance search, and it will also be accompanied by other attributes filtering, oth ...

Posted on Wed, 19 Jun 2019 15:27:21 -0700 by daniish

Massive Extreme Speed Multidimensional Retrieval of Time, Space and Objects-Best Practice of RDS PostgreSQL in Aliyun

Label PostgreSQL, Time, Space, Object Attributes, Multidimensional Retrieval, Massive, Spatial Index, Data Partition, Block Index BRIN, Multilevel Index, GIN Inverted Index, JSON Index, Multilevel Index, Multilevel Index, Multi-Index Scan Merge, Bitmap And Bitmap Or, Physical Scan, ctid Scan, Interect, Index, Partition Index, Partition Index ...

Posted on Tue, 11 Jun 2019 11:00:20 -0700 by Joseph Witchard

Application and Practice of Partition Index-Best Practice of RDS PostgreSQL in Aliyun

Label PostgreSQL , partial index , partition index background When tables are large, you may think of the concept of partitioned tables, such as user tables, which are partitioned into many tables by user ID hash or range. Another example is the behavior data table, which can be divided into many tables by time. Benefits of table disassembly ...

Posted on Tue, 11 Jun 2019 10:53:16 -0700 by smordue

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

B-tree index for PostgreSQL

structure The B-tree index is suitable for storing sorted data.For this data type, you need to define operators greater than, greater than or equal to, less than, or less than or equal to. Normally, B-tree index records are stored in the data page.Records in leaf pages contain index data (keys) and pointers to heap tuple records (i.e., tab ...

Posted on Thu, 06 Jun 2019 11:03:29 -0700 by DeadDude

The Use of Path Key and Index in PgSQL Source Analysis PG Optimizer in Sorting

outline The processing of SQL in PostgreSQL is similar to that in pipeline mode, which is successively made up of: Lexical and grammatical parsing. After generating parsing tree, it is handed over to semantic parsing. Semantic parsing, generating query tree, and handing it to Planner Planner generates an execution plan based on the query ...

Posted on Sat, 01 Jun 2019 15:42:50 -0700 by Muppet9010

The Way to Self-redemption--Java (Data Processing)

Simple Data Processing Recently, we did a project to import the data from execl into the data and analyze the manufacturing data. In fact, we don't care what kind of data we want, just like you, I only care about the technical points and the functions we want to achieve. Come on, let's talk about technology. execl data imported into databa ...

Posted on Fri, 31 May 2019 17:31:21 -0700 by mlewczuk

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