There are couple of ways you can optimize the greenplum database. Bad performing queries may be the result of bad database design, improper distribution keys, badly written SQL and improper allocation of system resources. we will focus on
|
Greenplum database optimization - tips and tricks
Optimizing Database Design
Many performance issues can be improved by database design. Review your database design and ask yourself the following:
|
Optimizing Data Distribution
When you create a table in Greenplum Database, it is important to declare a distribution key that allows for even data distribution across all segments in the system. Because the segments work on a query in parallel, Greenplum Database will always be as fast as the slowest segment. If the data is unbalanced, the segments that have more data will return their results slower. |
1-2 of 2