PostgreSQL Opens the Door to Space and Time

This article discusses spatiotemporal data and its wide usage in multiple domains, such as indoor positioning, pilotless driving, and scientific research.

Comparison Between PostgreSQL 10 and Greenplum in Spatiotemporal Object Selection and Data Pivoting

In this article, the author discusses spatiotemporal object selection and data pivoting and extensively compares PostgreSQL 10 and Greenplum in this respect with example code.

PostgreSQL Best Practices: Spatial Aggregation Analysis

In this article, the author discusses spatial aggregation analysis with examples and explores spatial object aggregation, data analysis, and business scenarios.

PostgreSQL Best Practices: Selection and Optimization of PostGIS Spatial Indexes (GiST, BRIN, and R-tree)

This article discusses the index types supported by PostgreSQL and compares GiST and BRIN indexes' performance concerning spatial search requirements.

How to Sync Up Data from MaxCompute to Greenplum with DataWorks

We will show you how to use the data sync feature of DataWorks to synchronize data from MaxCompute to Greenplum, one of the most popular MPP databases.

Use Kettle to Import Data to AnalyticDB for PostgreSQL

In this blog, you will learn about Kettle and how you can use Kettle to migrate data to AnalyticDB for PostgreSQL