Author Archives: skahler

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

Greenplum Database 4.3.3 Adds Delta Compression

I’ve been working with Greenplum for years now and of all the minor releases I’ve seen I have to say 4.3.3 is one of my favorites. This minor release included things like: Netbackup integration PL/R update to 3.1 Fuzzy String … Continue reading

Posted in Version Release | 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

Benchmarks for R510 Greenplum Nodes

gpcheckperf results from hammering against a couple of our R510s. The servers are setup with 12 3.5 600GB 15k SAS6 disks split into four virtual disks. The first 6 are one group and 50GB is split off for an OS … Continue reading

Posted in Benchmarking | 3 Comments