Tag Archives: Greenplum

Turn Analyze up to 10

If you are a Greenplum admin you have probably written more than a few scripts to help you keep your tables analyzed. That or you frequently find yourself harassing users to keep their table stats fresh, since having accurate stats … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Greenplum is Open

Greenplum is now open, as in open source. greenplum.org is the site with all of the info and you can checkout the source yourself on github. Pivotal has been working to this internally for awhile and it is a huge step … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

GPDB on VM, it is a different beast

I get a large number of asks about virtualizing GPDB. Yes you can, that is the short answer. GPDB is software and all it really cares about is having the proper OS under it and it will run. Will it run … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

What kind of disk performance does your GP see?

During our regular maintenance widows I run a gpcheckperf to see where our disk speeds in the Greenplum cluster are coming in. This is a result from an C2100 with a single LSI 9260-8i  controller. There are two virtual disk … Continue reading

Posted in Benchmarking | Tagged , , | Leave a comment