Frequently Asked Questions
What does Mugnano Data Consulting do?
We help teams adopt, tune, secure, and automate Greenplum/MPP data platforms. Outcomes include faster onboarding, predictable operations, optimized application design with governance built into the development process, and measurable performance gains.
Which platforms do you support?
We specialize in VMware Tanzu Greenplum, EDB WarehousePG, EDB PostgresAI, Apache Cloudberry, SynxData, and other PostgreSQL-derived MPP systems.
How do we get started?
Contact us for a discovery call. We’ll map goals, define success criteria, and create a phased plan with clear deliverables.
Can you work with us through another approved vendor (like EDB)?
If your organization’s vendor policies prevent engaging with us directly, we can deliver your project through one of our trusted subcontracting partners. This keeps you compliant with procurement rules while ensuring you still receive the same hands-on expertise and delivery model — you’ll work with Louis Mugnano directly on the engagement.
How it works:
• Your organization contracts with an approved vendor partner.
• The partner subcontracts the work to Mugnano Data Consulting (MDC).
• MDC remains the primary delivery lead and day-to-day point of contact.
Note: this structure may introduce a modest additional cost because intermediaries add their own margin. For example, we’ve successfully delivered projects across Central and South America through Bulky Consultoria e Soluções Ltda, a firm with established vendor relationships with Dell and Broadcom. In addition, our services are also offered through EnterpriseDB, one of the largest enterprise Postgres vendors. Our services would primarily be for EDB's WarehousePG product.
What is database onboarding?
Onboarding is the process of standing up a new database environment and aligning it with best practices for hardware, OS, network, and cluster design. With Greenplum/MPP systems, it includes validation with workload tests, training for SysAdmins and DBAs, and a detailed Cluster Install Report.
Read the Onboarding Service Overview (PDF)What is the DBA Operations Kickstarter?
A focused enablement program with automation (partition maintenance, health checks, backup workflows), runbooks, and training so DBAs can operate Greenplum confidently.
Read the DBA Operations Kickstarter Overview (PDF)What is the difference between logical and physical data modeling?
Logical modeling defines business entities and relationships (the “what”), while physical modeling implements them in a database (the “how”). We help clients bridge the two, especially for MPP platforms like Greenplum.
Why does modeling for MPP databases differ from traditional databases?
Because queries are distributed across segments, physical design choices like partitioning, distribution, and storage options affect performance far more than in single-instance systems. Having a Data Modeling Tool that allows you to include this in the model and generate full DDL makes the Tool an integrated part of development and not just a documentation tool.
When should I use partitioning?
Partitioning improves query performance on large tables and makes data maintenance (archiving, purging, rolling windows) easier. We provide automation to keep partitions aligned with business calendars.
What is dimensional modeling and why is it important?
Dimensional modeling structures data into fact and dimension tables, which makes analytics faster and easier for BI/reporting teams. This ease of reporting oftens enables self-service BI for the business users. We guide clients through Kimball-style designs and provide tooling adapted for MPP environments.
Read the Dimensional Modeling Service Offering (PDF)