PostgreSQL, Securities, Time Series Data, JSON, HSTORE, Array, range Index, BRIN Block Index, Time Sharing Trend, Linear Regression, MADlib, Machine Learning
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
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
PostgreSQL, PostGIS, Composite Index, btree_gist, Shared Bicycle
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
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
PostgreSQL , partial index , partition index
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
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:
Posted on Sun, 09 Jun 2019 16:30:01 -0700 by hagman
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 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
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
PostgreSQL, GIS, PostGIS, Greenplum, Spatial Retrieval, GiST, B-Tree, Gehash
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