Category Archives: Uncategorized

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

Will Hadoop knock out the MPP DB?

I was reading an excellent post ( When should I use Greenplum Database versus HAWQ? ) by my colleague Jon Roberts. Which got me thinking I should drop a post on why I still think MPP database and specifically Greenplum DB are … Continue reading

Posted in Uncategorized | Leave a comment

4.3 out and about

Greenplum Database 4.3 rolled out earlier this month and there are some big changes. Append-Optimized Tables: UPDATE and DELETE operations are enabled on what were previously Append-Only tables. Master Mirroring Enhanced: The way Master/StandbyMaster replication is implemented has changed. This … Continue reading

Posted in Uncategorized | Leave a comment

Database Landscape

Data nerd goodness from the 451 group

Posted in Uncategorized | Leave a comment

Stability and finding insight

Since the roll out of Greenplum 4.2 in combination with Greenplum on-site for a little training our clusters stability over the last year has improved. The main issues we run into at this point in time is lack of space … Continue reading

Posted in Uncategorized | 1 Comment

LSI 9260-8i fails

One of our clusters we tried out used C2100s and these LSI 9260-8i controllers. They ran fantastically out of the gate, but we started to run into some issues. I can attest to the fact that our rack of servers … Continue reading

Posted in Uncategorized | 2 Comments

Testing out UAC

I haven’t been a big fan of Greenplum’s performance monitoring tools. It’s been a couple years though so it’s time to try them again and see what we’ve got. So just got UAC up and running today and it’s looking … Continue reading

Posted in Uncategorized | Leave a comment

Finding trouble spots

I’ve been fighting some database performance issues recently and started to use the following query to look for tables that are being used that are showing that they have 0 rows. These are likely to be unanalyzed tables being used … Continue reading

Posted in Uncategorized | Leave a comment