Author | Nihal Jain Troubleshooting and identifying supportability issues in a complex database system can be a daunting task. However, with the advent of tools like gpsupport, the process has become much simpler and more efficient. gpsupport is a powerful diagnostic utility provided by VMware Greenplum that enables database administrators to identify, analyze, and resolve … gpsupport: Support Utility for VMware Greenplum Read More ..read more

Greenplum Database is a massively parallel processing (MPP) database designed for high-performance analytics and data warehousing. Similar to handling other MPP databases, it mandates routine query refinement, resource allocation adjustments, and data safeguarding. Within this blog post, we will delve into five indispensable guidelines tailored to the effective management of Greenplum ..read more

Author | Wen Lin Introduction Greenplum is an open-source, massively parallel data warehouse designed for analytics and AI applications. Efficient data compression is vital in Greenplum to reduce storage space and improve query performance. Greenplum offers several techniques for compressing data, reducing storage costs, and improving query performance. In this blog post, we will explore … 10 Examples of Compression Enablement in Greenplum Read More ..read more

Frequently tuned Greenplum parameters: Please find below the list of most commonly used Greenplum parameters.  Tuning these parameters can assist with the efficient memory management, performance tuning, resource and connection management of your Greenplum database. Please test these parameter changes on Dev or QA environments before implementing them on Production. Some of these parameters can … Commonly tuned parameters in GP7 Read More ..read more

Author | David Kimura Greenplum Database is a massively parallel processing (MPP) database designed for handling large-scale data warehousing and analytics workloads. One of its key features is the ability to partition tables, which helps improve query performance, manage data distribution, and enhance data organization. In this blog post, we will explore 20 examples of … 20 Examples of Greenplum 7 Partition Commands Read More ..read more

The release of Greenplum Database 7 (GPDB7) brings with it many new features, and each of them requires some thought to make sure we get the most out of them. Today, I want to talk about the tweaks we on the Greenplum Kernel team have made to get the most out of the new partitioning … Parallel Restore and Partitioned Tables in GPDB Read More ..read more

Author | Huasong Fu The ALTER TABLE commands are commonly used for operations like adding columns, changing the column data type, and many more. In many cases, such commands require the whole table to be rewritten while holding an exclusive lock on the table. For large tables this can be a very time-consuming process. As a … ALTER TABLE in Greenplum 7: Avoiding Table Rewrite Read More ..read more

We recently released GreenplumPython, a Python library that allows users to interact with Greenplum or PostgreSQL in a Pythonic way. GreenplumPython provides a pandas-like table API that is familiar and intuitive to Python users. GreenplumPython is making it powerful for performing complex analyses such as statistical analysis with UDFs and UDAs. It encapsulates common best … How to Play Python3 with GPDB6 Read More ..read more

Big Data and AI in healthcare offer precise decision-making, personalized treatments, and efficiency enhancements. Merging structured and unstructured data provides a holistic patient view, while technologies like Greenplum and GPUs optimize data processing. Challenges remain, but solutions are emerging ..read more

ALTER TABLE in Greenplum 7: Avoiding Table Rewrite The ALTER TABLE commands are commonly used for operations like adding columns, changing the column data type, and many more. In many cases, such commands require the whole table to be rewritten while holding an exclusive lock on the table. For large tables this can be a very … ALTER TABLE in Greenplum 7: Avoiding Table Rewrite Read More ..read more