WarehousePG Architectural Optimization

Services Overview

The EDB WarehousePG Architectural Optimization is designed to ensure the health and stability of your WarehousePG analytics platform. An EDB Consultant will work directly with your team to provide a comprehensive review of your proposed platform to ensure maximum scale and performance.

The service comes in three sizes, depending on the width of analysis needed by your team:   

Scope of Services

An EDB consultant will review and analyze the customer's analytics architecture, focusing on the following key areas:

• Data Model Assessment: Reviewing the overall data model and schema design. This includes assessing the table distribution strategy to minimize data skew and optimize queries, as well as evaluating the partitioning and indexing strategy
• Security: Reviewing security and access controls
• Workload Analysis: Evaluating the loading architecture/strategy and analyzing workload patterns alongside resource management

Deliverables

At the conclusion of the engagement, EDB will provide:

Comprehensive Architectural Readiness Report A detailed document providing a holistic view of your analytics platform readiness health, containing:

• Architecture Assessment Report: an evaluation of your current analytics architecture, including a thorough review of existing ETL/ELT pipelines, security, and access controls. Highlights current structural bottlenecks and verifies whether your system aligns with best practices for enterprise-scale analytics
• Data Model Optimization Recommendations: Actionable guidance on table distribution strategies to effectively minimize data skew and accelerate overall query performance. Specific recommendations for partitioning and indexing to ensure your schema design is fully optimized for complex, high-volume analytical workloads
• Capacity Planning Guideline: Recommendations infrastructure sizing and resource management configurations to ensure your environment is appropriately provisioned to handle future data growth and performance demands

Report Review: A review of the report and findings with the customer via web conference

Roles & Responsibilities

EDB Project Manager:  Responsible for initial planning, task alignment, and project closeout.

EDB Solution Architect: Technical Lead, responsible for workshop delivery, analysis, validation and documentation

Customer Team: Responsible for providing the main point of contact for the existing cluster requirements. Resources and Roles (or similar Technical Stakeholders) where input may be needed for the engagement include:

• Database Administrator
• System Architect
• Application Owner
• Infrastructure Manager 
• Network Administrator
• Security Officer

Assumptions

• A project kickoff will be conducted to review the service scope and confirm the schedule
• This service is delivered remotely unless otherwise agreed
• Customers will provide the names, title, email, phone number, and area of responsibility of those participating. One person will be designated as the main contact, and will be able to provide access to the people most knowledgeable about the topics to be discussed or examined. 
• Customers will make appropriate personnel available to assist EDB in the performance of the services as needed and requested by EDB in a timely manner so as not to disrupt the project schedule. 
• Customers will not provide Personal Data (as defined in applicable law). Customer agrees that it will work with EnterpriseDB to ensure that all such data is not provided.  
• Customer is responsible for providing all necessary internal design and project related documentation where EDB is required to analyze, and provide access to customer implemented systems.
• Customers will ensure timely access to all systems through screen sharing and experts including third parties as required. 
• Customers will assign the appropriate resources with the appropriate privileges for the task being planned for any screen sharing sessions as needed throughout the engagement.

Prerequisites

• Customer will identify target cluster depending on the size of review purchased
• Customer will provide resource availability for workshop planning and a point of contact for coordination. 
• Customer is responsible for providing all necessary internal design and project related documentation and requirements where EDB is required to analyze, operate, or modify customer implemented systems